The Query Builder dialog in the Join mode allows you to create custom joins in ABL for the selected query.
Access this dialog by selecting Join option on the Query Builder dialog.
This dialog includes the following options:
| Join | Specify which join in the query being built to customize. Select the query from the Join list. |
| 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.
|
| (table) | Displays all the fields for table on the left of the selected join. Use to add fields to the Join Criteria editor. |
| (table) | Displays all the fields for the table on the right of the selected join. Use to add fields to the Join Criteria editor. |
| = (Equal) | Select this option to construct an equal (=) comparison between fields. This generates the comparison in ABL code in the Join Criteria editor. |
| <> (Not Equal) | Select this option to construct a not equal (<>) comparison between fields. This generates the comparison in ABL code in the Join Criteria editor. |
| < (Less Than) | Select this option to construct a less than (<) comparison between fields. This generates the comparison in ABL code in the Join Criteria editor. |
| > (Greater Than) | Select this option to constructs a greater than (>) comparison between fields. This generates the comparison in ABL code in the Join Criteria editor. |
| <= (Less Than or Equal) | Select this option to construct a less than or equal (<=) comparison between fields. This generates the comparison in ABL code in the Join Criteria editor. |
| >= (Greater Than or Equal) | Select this option to construct a greater than or equal (>=) comparison between fields. This generates the comparison in ABL code in the Join Criteria editor. |
| AND | Select this option to construct an AND conjunction between two logical expressions in the ABL code in the Join Criteria editor. |
| OR | Select this option to construct an OR conjunction between two logical expressions in the ABL code in the Join Criteria editor. |
| Customize Join | Select this option to change the default join criteria using the WHERE clause. By default, the GUI Designer attempts to join tables using OF. |
| Join Criteria | Displays the join you are creating. You may also edit the query directly in this editor when it has focus. |
| Undo | Select this option to undo the last edit made to the Join Criteria editor. |
| 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. |