Data.SqlExpr.TSQLTable.IndexName
Delphi
property IndexName: string read FIndexName write SetIndexName;
C++
__property System::UnicodeString IndexName = {read=FIndexName, write=SetIndexName};
Properties
Type | Visibility | Source | Unit | Parent |
---|---|---|---|---|
property | published | Data.SqlExpr.pas Data.SqlExpr.hpp |
Data.SqlExpr | TSQLTable |
Description
Identifies an index to use for sorting records and for linking the table as the detail of a master/detail relationship.
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.