FireDAC.Comp.Client.TFDTable.IndexFieldNames
Delphi
property IndexFieldNames: string read GetIndexFieldNames write SetIndexFieldNames default 0;
C++
__property IndexFieldNames = {default=0};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | FireDAC.Comp.Client.pas FireDAC.Comp.Client.hpp |
FireDAC.Comp.Client | TFDTable |
Description
Lists the field names to use as an index.
FireDAC.Comp.Client.TFDTable.IndexFieldNames inherits from FireDAC.Comp.DataSet.TFDDataSet.IndexFieldNames. All content below this line refers to FireDAC.Comp.DataSet.TFDDataSet.IndexFieldNames.
Lists the field names to use as an index.
Use IndexFieldNames as an alternative method of specifying the current index to use for a dataset.
Specify the name of each field on which to index the dataset, separating names with semicolons. Field names order is significant. Optionally specify the postfix for any of fields in the form field[:[D][A][N]], where:
D--use descending sorting on this field.A--use ascending sorting on this field.N--use case-insensitive sorting on this field.
Use IndexFieldNames to create sort orders on-the-fly. The IndexFieldNames and IndexName properties are mutually exclusive. Setting one clears the other.
Example
FDQuery1.IndexFieldNames := 'order_date;customer_name:N';
See Also
Samples
- FireDAC TFDQuery Indices sample