TSQLTable.IndexName Property

Identifies an index to use for sorting records and for linking the table as the detail of a master/detail relationship.

Pascal

property IndexName: WideString;

C++

__property BSTR IndexName;

Description

Use IndexName to specify an existing index that is defined for the underlying database table.

IndexName is used to sort records in the table by appearing in the ORDER BY clause of the SQL statement automatically generated to fetch records for the dataset.

IndexName is also used to link this table as the detail in a master/detail relationship. Each of the fields in the index must be matched to a corresponding field from the MasterFields property.

Note: The IndexName and IndexFieldNames properties are mutually exclusive. Setting one automatically clears the other.