The Query Builder dialog in the Table mode allows you to add and remove tables to the selected query.
Access this mode by selecting the Table option on the Query Builder dialog.
This dialog includes the following options:
| Database | Select a database from the list of connected databases. |
| 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 Tables | Displays the tables of the selected database. You can select tables to add to the Selected Tables & Joins section. |
| Add >> | Allows you to add selected tables to the Selected Tables & Joins list. These tables are included in the query that the GUI Designer creates. |
| << Remove | Allows you to remove tables from the Selected Tables & Joins list. |
| Selected Tables & Joins | Displays the tables that are selected from the Available Tables with their join partners that you have created. |
| Lock-Type | Allows you to select the table access mode for the defined query. The available options are: No-lock (the default), Share-lock, or Exclusive-lock. |
| Switch Join Partners | Select this option to change the table in the highlighted join. |
| Query | Displays the query you are creating. |
| Indexed-Reposition | Select this option to enable INDEXED-REPOSITION. If you specify this option, OpenEdge attempts to optimize subsequent REPOSITION TO RECID operations on the query. (Only available for single table queries.) |
| 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 syntax of the query when you click OK . |
| Freeform Query | Displays the PROGRESS Advisor dialog which allows freeform editing of the query using the GUI Designer editor. |