Selecting Data Records Using Search Conditions


To display only certain data records of a table, you can enter search conditions in the Form dialog.


1.       To display the window area for entering the search conditions, select the Filter flag.

2.       Formulate your search conditions for the appropriate table columns. Select the required predicate, and enter comparison values or relational expressions.

3.       Enter how the formulated search condition is to be linked with the next search condition.

4.       Choose Refresh. SQL Studio downloads the data records from the database.

For information on the syntax of predicates, see the Predicate section of the SQL Reference Manual.