Online Documentation for SQL Query for InterBase/FireBird

Setting criteria

Use the Criteria tab to set the selection conditions.

To add a condition, click the ellipsis button on the left, and select the Add condition popup menu item.

Edit the condition by clicking the elements of the condition pattern and setting the necessary values. Clicking the numbered button to the left of the condition string 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, expand or collapse enclosure levels of the condition (if the condition is composite).

A simple condition pattern contains three elements: an argument, a condition operator and a second argument (if required for the condition).

Clicking each element field allows you to set its value. When clicking the argument field, you can edit the argument as a text string: set an object name or a certain value in this field. Right-clicking the field in the edit mode activates the popup menu with the Insert field function (also called by Shift+Enter shortcut). This function allows you to select a field from the list of all the table fields.

Clicking the condition operator field activates the popup menu where you can specify the condition you need.

The way the conditions are used is set in the upper string of the area (All, Any, None or Not all of the following are met). Click the green link to change it.