Set Sequencing

Use this system function to create the ORDER BY clause of a SQL search statement for use in a succeeding fetch.

Note: Use of this system function implies that grid formats that include sequencing will not be used in the SQL.

Parameters

Grid: Input, required. The grid FC to affect.
Table: Input, required. The source from which to acquire comparison data. Set the parameter to an alphanumeric constant (<Literal>), <Null>, or an applicable object from the object list.
Alias: Input, required. The column of the table from which to acquire comparison data. Set the parameter to an alphanumeric constant (<Literal>), <Null>, or an applicable object from the object list.
Sort Order: Input, required. Whether to sort in ascending or descending order. Set the parameter to <Ascending> or <Descending>.

Additional Notes

In general, this system function should not be used in cases where the user can affect the select. For example, QBE and filter fields are ways the user can affect the select. If the user can affect the select, then the user's select information should always be taken into consideration.