RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TTable.IndexFieldNames Property
TTable Class | TTable Members | DBTables Namespace | Description | See Also
Collapse All

Lists the columns to use as an index for a table.

Pascal
property IndexFieldNames: string;
C++
__property AnsiString IndexFieldNames;
Description

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.
 

 

See Also

IndexDefs 

IndexName 

Creating an Index with IndexFieldNames 

Specifying the Data to Display using TSQLDataSet

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!