Bde.DBTables.TTable.IndexFieldNames
Delphi
property IndexFieldNames: string read GetIndexFieldNames write SetIndexFieldNames;
C++
__property System::UnicodeString IndexFieldNames = {read=GetIndexFieldNames, write=SetIndexFieldNames};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | Bde.DBTables.pas Bde.DBTables.hpp |
Bde.DBTables | TTable |
Description
Lists the columns to use as an index for a table.
Use IndexFieldNames as an alternative method of specifying the index to use for a table. In IndexFieldNames, specify the name of each column to use as an index for a table. Ordering of column names is significant. Separate names with semicolon.
For Paradox and dBASE any column names specified in IndexFieldNames must already be indexed. This must be a single index using the same fields in the same order as specified in IndexFieldNames.
For SQL-based tables, the specified columns need not be indexed.
Note: The IndexFieldNames and IndexName properties are mutually exclusive. Setting one clears the other.