Performing a Query
Editing a Query in SQL Syntax

On the Native SQL tab page, the query created by Chromeleon is displayed in SQL syntax. (For information about how to open these tab pages, refer to  Specifying the Sample Query Using the Dialog Box.)

If you have a good knowledge of SQL, you can use the Native SQL tab page to specify your Query further. Select the Always use native SQL check box and modify the statement via the keyboard.

 Tip:

If you have edited the SQL statement on the Native SQL tab page, this edited SQL statement is used whenever the query is performed, as long as the Always use native SQL check box remains selected. When you clear the check box, the current entries from the SQL and Result Restrictions tab pages are used, overwriting your SQL entries on the Native SQL tab page.