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
design canvas. 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. |