FireDAC.Comp.DataSet.TFDIndex.Options

• Up to Parent: TFDIndex

Delphi

property Options: TFDSortOptions read FOptions write SetOptions default [];

C++

__property Firedac::Stan::Intf::TFDSortOptions Options = {read=FOptions, write=SetOptions, default=0};

Properties

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

Description

Specifies sorting options.

Use Options to specify the sorting options for the dataset view:

Option	Description
soNoCase	Use case-insensitive sorting for all fields or expression results.
soNullFirst	Put NULL values before non-NULL values when sorting in ascending order. Otherwise, NULL values are put after non-NULL values.
soDescNullLast	Put NULL values after not-NULL values when sorting in descending order. Otherwise, NULL values are put before non-NULL values..
soDescending	Use the descending order for full sorting.
soUnique	Enforce uniqueness in the view. If the application tries to insert a new record with duplicated sorting field values and TFDDataSet.ConstraintsEnabled is True, an exception is raised.
soPrimary	Same as above, but the dataset view is used with soPrimary.
soNoSymbols	Ignore symbols when comparing strings to build the sort order.

The default value is an empty set. Note that soDescNullLast and soNullFirst are ignored by TFDTable, and that the NULL position is determined by the DBMS.

See Also

• FireDAC.Comp.DataSet.TFDIndex.Fields