SQL View Clause Text Box
The SQL View Clause text box in the CONNX Data Dictionary Manager window uses the same syntax as the WHERE clause in an SQL statement.
For example, for the following clause:
SELECT * FROM testtable WHERE recordtype = "O"
in the SQL View Clause text box, it is not necessary to enter the word WHERE:
recordtype = "O"
If you enter the word WHERE, you will receive a syntax error when attempting to view the data for the table.