User's Guide

Defining criteria

Index  Previous  Next

To define criteria for the expression listed in the Columns Pane you must use the Criteria column.

There you should write the criterion omitting the expression itself. To get the following criterion in your query

WHERE (field >= 10) AND (field <= 20)

you should write

>= 10 AND <= 20

in the Criteria column.

You may specify several criteria for a single expression using the Or... columns. These criteria will be concatenated in the query using the OR operator.

Index  Previous  Next