Define query conditions

Sometimes there are specific conditions that need to be set in the query , such as searching for a specific element, or comparing numeric or alphabetical values. To set a condition, click the button next to the condition text box:

A new window like the one below will appear:

To set the dialog box options, follow the next steps:

1. The Table Column text box is disabled and it displays the alias and the name of the table column for which you are writing the condition.

2. In the Condition drop-down menu select the type of comparison. There are options for comparisons of numeric fields and character strings: =, >, >=, <, <=, !=, begins with, contains, ends with, is null, is not null.

3. In the Variable Type drop-down menu select the type for the dynamic variable to be compared with the database value. The available options are: Form Variable, URL Variable, Session Variable, Cookie Variable, Entered Variable.

4. In the Run-time Value text box enter the value that will be considered at run-time.

5. In the Default Value text box enter the default value.

6. Click OK when you are done.

The next topic will explain how to use the SQL/Query Preview Panel for checking the accuracy of the generated query.