|
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.
|