FireDAC.Comp.DataSet.TFDIndex.Fields

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property Fields: String read FFields write SetFields;

C++

__property System::UnicodeString Fields = {read=FFields, write=SetFields};

Properties

Type Visibility Source Unit Parent
property published
FireDAC.Comp.DataSet.pas
FireDAC.Comp.DataSet.hpp
FireDAC.Comp.DataSet TFDIndex

Description

Identifies the fields that comprise the index.

Set the Fields property value to the ';' separated list of field names with optional modifiers. The dataset view records are ordered by these field values.

The general syntax for the property value is: field[:[D][A][N]][;...], where:

  • D is the descending modifier (DescFields can also be used).
  • A is the ascending modifier (the default order).
  • N is the case-insensitive modifier. (CaseInsFields can also be used).

Assigning a value to the Fields property erases the value of the Expression. The view sort order can be either expressional (Expression is specified) or field list-based (Fields is specified).

Alternatively, you can use Options to setup sorting.

See Also