Access this mode by selecting Options on the Query Builder dialog.
This dialog includes the following options:
| Fields | Displays the Column Editor dialog which
allows you to specify which fields to display in the browse. Note: This option is only available when editing a query
associated with a browse widget.
|
| Table | Lists the current tables in the selected query. |
| Find | Lists the find parameter for table in the selected row. Use to the set the find parameter for a table to FIND EACH, FIND FIRST, or FIND LAST. The default is FIND EACH. You can double-click in this field to cycle through the valid choices or press 'E', 'F' or 'L' to select Find Each, Find First or Find Last, respectively. |
| Join | Lists whether the joins for the tables in the selected row are inner joins or outer joins. Use to set the join type for a table to inner or outer. The default join type is inner. You can double-click to cycle through the valid choices or press 'I' for Inner or 'O' for Outer. |
| Returned | Lists what fields the selected query will return for each table. Use to set the fields in the Field-List for a table to All Fields or Fields Used. When you select Fields Used, the query returns only those fields in the FIELDS-IN-QUERY preprocessor list. The default is All Fields. You can double-click to cycle through the valid choices or press 'A' for All Fields or 'F' for Fields Used. |
| Query Tuning Options | Enter ABL code in this editor to specify query tuning parameters for the selected query. It is recommended to reference an include file so that all queries in an application can be easily modified by modifying the contents of the include file instead of referencing this dialog for each query. |
| Key-Phrase | Select this check box to add the Key-Phrase preprocessor variable to the query definition. |
| SortBy-Phrase | Select this check box to add the SortBy-Phrase preprocessor variable to the query definition. If you use select this option, you cannot directly modify the Sort from the Query Builder. |
| Check Syntax Now | Select this option to have the compiler check the syntax of the query in its current state. |
| Check Syntax On OK | Select this option to have the compiler check the query syntax when you click OK . |
| Freeform Query | Displays the PROGRESS Advisor dialog which allows freeform editing of the query using the GUI Designer editor. |