Query Builder Dialog Box -- Sort Mode

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.