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.
Example:
SELECT * FROM testtable WHERE recordtype = "O"
Using this example, you would enter only:
recordtype = "O"
in the SQL View Clause text box. You do not need to enter the word WHERE in the SQL View Clause text box, as it is implied. If you enter the word WHERE, you will receive a syntax error when attempting to view the data for the table.
