Progress
AppBuilder
Developer’s Guide


Sort Mode

To specify the sort order you want for your query, activate the Sort radio-set button. The Query Builder enters Sort mode and appears as in Figure 4–10.

Figure 4–10: Query Builder in Sort Mode

NOTE: If your query uses the {&SORTBY–PHRASE} preprocessor value to specify a sort order for the final result, the AppBuilder prevents you from entering this Sort mode by making the Sort button insensitive. You can set the query to use the {&SORTBY–PHRASE} from the Options mode of the Query Builder. For more information, see the "Options Mode" section in this chapter.

To specify the sort criteria, select fields from the Available Fields list. The Table combo box allows you to move between tables if you chose more than one table while in Table mode.

In the Sort Criteria editor, AppBuilder displays the fields you choose and the sort criteria you specify. When you choose OK, the sort criteria is also displayed in Table mode. The Ascending and Descending radio buttons allow you to specify the display order of the sorted records.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095