Query Builder -
Expression
Builder
The Expression Builder allows you
to generate a WHERE clause to specify search criteria for your
query. The Expression Builder contains the following elements:
- Where Criteria Editor
- Displays the WHERE clause as
you construct it using the editor. Also allows you to
edit the expression directly.
-
- Table Icon
- Displays all the fields from
the selected table, and from other tables above the
selected table in the list. Double-click on a field to
place it in the Where Criteria editor.
-
- Operators: You
can select from the following list to insert operators in
your expression:
-
- = (Equal)
- Constructs an equal
(=) operator between fields. Generates this
comparison in the Where Criteria editor.
-
- <> (Not Equal)
- Inserts a not equal
(<>) operator between fields. Generates
this comparison in the Where Criteria editor.
-
- < (Less Than)
- Inserts a less than
(<) operator between fields. Generates this
comparison in the Where Criteria editor.
-
- > (Greater Than)
- Inserts a greater
than (>) operator between fields. Generates
this comparison in the Where Criteria editor.
-
- <= (Less Than or
Equal)
- Inserts a less than
or equal (<=) operator between fields.
Generates this comparison in the Where Criteria
editor.
-
- >= (Greater Than
or Equal)
- Inserts a greater
than or equal (>=) operator between fields.
Generates this comparison in the Where Criteria
editor.
-
- AND
- Inserts an AND
operator between two logical expressions in the
Where Criteria editor.
-
- OR
- Inserts an OR
operator between two logical expressions in the
Where Criteria editor.
-
- NOT
- Inserts a NOT
qualifier on one logical expression in the Where
Criteria editor.
-
- Matches
- Creates a MATCHES
operator for character fields in the Where
Criteria editor.
-
- Begins
- Inserts a BEGINS
operator between character fields in the Where
Criteria editor.
-
- (...)
- Inserts parentheses (
) around any selected string in the Where
Criteria Editor.
-
- OK
- Accepts the code in the Where
Criteria Editor, removes the dialog box, and displays the
code in the Expression Builder frame.
-
- Cancel
- Cancels changes and removes
the dialog box.
How to
Use Workshop- WebSpeed
Glossary
WebSpeed Library