FireDAC.Comp.DataSet.TFDDataSet.IndexFieldNames

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property IndexFieldNames: String read GetIndexFieldNames write SetIndexFieldNames;

C++

__property System::UnicodeString IndexFieldNames = {read=GetIndexFieldNames, write=SetIndexFieldNames};

Properties

Type Visibility Source Unit Parent
property public
FireDAC.Comp.DataSet.pas
FireDAC.Comp.DataSet.hpp
FireDAC.Comp.DataSet TFDDataSet

Description

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