Data.SqlExpr.TCustomSQLDataSet.SortFieldNames
Delphi
property SortFieldNames: string read GetSortFieldNames write SetSortFieldNames;
C++
__property System::UnicodeString SortFieldNames = {read=GetSortFieldNames, write=SetSortFieldNames};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | protected | Data.SqlExpr.pas Data.SqlExpr.hpp |
Data.SqlExpr | TCustomSQLDataSet |
Description
Indicates the sort order when CommandType is ctTable.
Use SortFieldNames to specify the fields that should be used to order the records in the dataset. SortFieldNames is only used when CommandType is ctTable.
SortFieldNames is a semicolon-delimited list of field names. These names are used to generate the ORDER BY clause of the SQL statement the dataset creates to fetch data from a server table. Records are sorted by the first named field, and within that sort order, by the second named field, and so on.