Add Restrictions to the Where Clause
The Where Clause Editor lets you define the selection criteria (that is, restrict the criteria) for the tables you want the database to access. You can create or delete where clause restrictions.
To create or edit a where clause restriction in the Query Editor
1. Click Edit, Where Clause.
The Where Clause Editor appears.
In the Where Clause Editor, toolbar buttons and corresponding menu commands are available for creating, editing, and deleting a where clause restriction.
Toolbar buttons and corresponding menu toggle commands are also available for viewing the where clause restriction text, for viewing the where clause restriction graphically, and for viewing SQL code for the where clause.
2. Click Edit, Graphic in the Where Clause Editor.
3. Double-click the graphic (rectangular box) in the graphic area of the Where Clause Editor.
The Reporter Query Columns dialog appears.
4. Select a table name and a column name.
5. Click Select.
The Reporter Query Restriction dialog appears.
The Reporter Query Restriction dialog shows the selected table/column name and lets you add or edit a query restriction.
6. If required, change the AND to OR by clicking the down arrow for the drop-down box on the upper left side of the dialog.
7. If required, change the operator by clicking the down arrow for the drop-down box on the left side of the dialog.
8. Type the text for the desired restriction in the entry field on the right.
9. Click OK.
The Where Clause Editor appears, showing both the text for the restriction you entered and its graphic representation.
10. Repeat steps 3 through 9 to add other restrictions to the where clause.
11. Click Save to save your work.
To delete a where clause restriction
1. Click the box associated with the restriction you want to delete in the graphic area.
2. Click Edit, Delete in the Where Clause Editor.
To close the Where Clause Editor
Click Close in the upper right corner of the window.
A confirmation pop-up appears.