TCustomDADataSet.SetOrderBy Method

Builds an ORDER BY clause of a SELECT statement.

procedure SetOrderBy(const Fields: string);

Parameters

Fields

Holds the names of the fields which will be added to the ORDER BY clause.

Call the SetOrderBy method to build an ORDER BY clause of a SELECT statement. The fields are identified by the comma-delimited field names.

Note: The GetOrderBy and SetOrderBy methods serve to process only quite simple queries and don't support, for example, subqueries.

Query1.SetOrderBy('DeptNo;DName');