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. Ordering of field names is significant. Optionally specify the postfix for any of fields in 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.
property IndexFieldNames: String;
ADQuery1.IndexFieldNames := 'order_date;customer_name:N';
What do you think about this topic? Send feedback!