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.

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.