Unique index for getting the table with Adox

xiaoxiao2021-03-06  58

The function of Adox is very powerful, but I didn't feel it, because I wrote a lot of programs under ASP, I can't run. I don't know why, there is a program that can get a unique index here. Some friends may do some general procedures, that is, regardless of how the data structure changes, the program is unchanged, from data entry, modification, deletion, to data retrieval. All modules are all completely independent of the database table. This requires the unique index of the table. Since the record is indicated by the unique index, that record is to be deleted. If a table is a regular table, there should be at least one unique index because the table should have a primary key, and the primary key is the only index. I tried to get the primary key of the table with adox.key! I do not know why. Also, I also try to use index's primarykey to get the index is the primary key, but no matter what the index is returned to True. Under the helplessness, only if it is determined whether it is unique. As a result, this method is really good. Just the last program returned is a string consisting of n (n> = 1) fields, which is separated by a comma (,). However, most unique indexes have a field constructed. We can also determine information such as these fields as needed. Squain this is not the only way to get the only index. Open a mode query through the OpenSchema method connection, you can also get the primary keyword of a table, see you see [? Here?].

转载请注明原文地址:https://www.9cbs.com/read-119046.html

New Post(0)