Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
TADIndex.Expression Property
TADIndex Class  TADIndex Members  uADCompDataSet Namespace  Example  published  See Also  Send Feedback

Specifies expression which must be used to sort records.

Group

published

Links
TADIndex Class, TADIndex Members, uADCompDataSet Namespace, Example, published, See Also
Description

Set Expression property value to a formula. The dataset view records will be ordered by these formula values, calculated for each record. 

Assignment to the Expression property value erases a Fields property value. The view sort order may be either expressional (Expression is specified), either field list based (Fields is specified). 

Also use Options to setup sorting.

Syntax
property Expression: String;
See Also
Example
ADQuery1.Indexes[0].Expression := 'Upper(Left(Name, 1))';
What do you think about this topic? Send feedback!