Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
TADDataSet.IndexFieldNames Property
TADDataSet Class  TADDataSet Members  uADCompDataSet Namespace  Example  public  See Also  Send Feedback

Lists the field names to use as an index.

Group

public

Links
TADDataSet Class, TADDataSet Members, uADCompDataSet Namespace, Example, public, See Also
Description

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.

Syntax
property IndexFieldNames: String;
See Also
Example
ADQuery1.IndexFieldNames := 'order_date;customer_name:N';
What do you think about this topic? Send feedback!