The Conditions tab of the Query Designer allows
you to define criteria for the SELECT, UPDATE, and DELETE queries. You can define
a number of conditions using columns from the query tables, create combined conditions
and link them with logical operators (AND, OR, NOT).
To add a condition, click the button at the left and select Add Condition
in the popup menu.
Each conditions consists of two parts and the condition operator. Click at the left
and right edit boxes to edit the condition parts and click at the linking operator
to change this operator.
For operators like and not like you can use the %
symbol to represent a number of any characters in the compare string, and
the ? symbol to represent any single character. For operators is
blank and is not blank there is only one condition part;
for operators between and not between there are
more than two parts in the condition.
Clicking the button at the left of the condition activates the popup menu, which
allows you to add a new condition of the same enclosure level, add a new enclosure
level, delete the current condition, open or close the condition, if it is composite.
©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.