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 |