Query Builder Dialog Box -- Where Mode

The Query Builder dialog in the Where mode allows you to generate a WHERE clause to specify search criteria in ABL for the selected query.

Access this mode by selecting the Where option on the Query Builder dialog.

This dialog includes the following options:

Table Select table for the where clause from the list of available tables.
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 the selected table. Select to add fields to the Where Criteria editor.
=(Equal) Select this option to construct an equal (=) comparison between fields. This generates the comparison in ABL code in the Where Criteria editor.
<>(Not Equal) Select this option to construct a not equal (<>) comparison between fields. This generates the comparison in ABL code in the Where Criteria editor.
< (Less Than) Select this option to construct a less than (<) comparison between fields. This generates the comparison in ABL code in the Where Criteria editor.
>(Greater Than) Select this option to construct a greater than (>) comparison between fields. This generates the comparison in ABL code in the Where Criteria editor.
<= (Less Thanor Equal) Select this option to construct a less than or equal (<=) comparison between fields. This generates the comparison in ABL code in the Where Criteria editor.
>= (Greater Thanor Equal) Select this option to construct a greater than or equal (>=) comparison between fields. This generates the comparison in ABL code in the Where Criteria editor.
AND Select this option to construct an AND conjunction between two logical expressions in ABL code in the Where Criteria editor.
OR Select this option to construct an OR conjunction between two logical expressions in ABL code in the Where Criteria editor.
Begins Select this option to create a BEGINS construction for character fields in the Where Criteria editor.
Contains Select this option to create a CONTAINS construction for word index fields in the Where Criteria editor.
Matches Select this option to create a MATCHES construction for character fields in the Where Criteria editor.
List Select this option to create a LIST construction for fields in the Where Criteria editor.
Range Select this option to create a RANGE construction for fields in the Where Criteria editor.
Where Criteria Displays the where criteria you are creating. You may also edit the query directly in this editor when it has focus.
Undo Choose to undo the last edit made to the Where 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.