Specifies expression which must be used to sort records.
Set Expression property value to a formula. The dataset view records will be ordered by these formula values, calculated for each record.
Also use Options to setup sorting.
property Expression: String;
ADQuery1.Indexes.Expression := 'Upper(Left(Name, 1))';
What do you think about this topic? Send feedback!