The Query Builder dialog in the Sort mode allows you to generate a SORT clause in ABL for the selected query.
Access this mode by selecting the Sort option on the Query Builder dialog.
This dialog includes the following options:
|Table||Select table for the sort clause from the list of available tables.|
|Fields||Displays the Column Editor dialog. which
allows you to specify which fields to display in the browse on the
Note: This option is only available when editing a query associated with a browse widget.
|Available Fields||Displays all the fields for the selected table. Select a field with which to specify sort criteria.|
|Selected Fields||Displays the fields selected to include in the sort criteria.|
|Add >>||Select this option to add fields to the Selected Fields list. Moves the highlighted fields in the Available Fields list to the Selected Fields list.|
|<< Remove||Select this option to remove fields from the Selected Fields list. Moves the highlighted fields in the Selected Fields list to the Available Fields list.|
|Move Up||Select this option to move the highlighted fields one position in the Selected Fields list.|
|Move Down||Select this option to move the highlighted field one position down in the Selected Fields list.|
|Ascending||Select this option to sort the fields in ascending order. This is the default sort option.|
|Descending||Select this option to sort the fields in descending order.|
|Sort Criteria||Displays the sort criteria you are creating.|
|Freeform Query||Displays the PROGRESS Advisor dialog which allows freeform editing of the query using the GUI Designer editor.|