Delphi - база знаний

       

Работа с индексами


Работа с индексами



Each function listed below returns information about an index or indexes, or performs a task that affects an index, such as dropping it, deleting it, or adding it.



DbiAddIndex:
Creates an index on an existing table.

DbiCloseIndex:


Closes the specified index on a cursor.

DbiCompareKeys:
Compares two key values based on the current index of the cursor.

DbiDeleteIndex:
Drops an index on a table.

DbiExtractKey:
Retrieves the key value for the current record of the given cursor or from the supplied record buffer.

DbiGetIndexDesc:
Retrieves the properties of the given index associated with the cursor.

DbiGetIndexDescs:
Retrieves index properties.

DbiGetIndexForField:
Returns the description of any useful index on the specified field.

DbiGetIndexSeqNo:
Retrieves the ordinal number of the index in the index list of the specified cursor.

DbiGetIndexTypeDesc:
Retrieves a description of the index type.

DbiOpenIndex:
Opens the index for the table associated with the cursor.

DbiRegenIndex:
Regenerates an index to make sure that it is up-to-date (all records currently in the table
are included in the index and are in the index order).

DbiRegenIndexes:
Regenerates all out-of-date indexes on a given table.

DbiSwitchToIndex:
Allows the user to change the active index order of the given cursor.


Взято с

Delphi Knowledge Base




Содержание раздела