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.

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