SQL Statement - Settings

Database Guide : Database Help : Database Functions Category : SQL Statement : SQL Statement - Settings

Use the SQL Statement - Settings window to specify the database and SQL statement you want the SQL Statement part to use.

If the SQL statement you want to use does not exist, you will need to create it or import it. You can also use this window to edit, export, or delete an SQL statement.

Note:

An SQL statement can only reference the tables, views, and columns contained in the database you specify. The SQL statement will be validated against the database when you select OK or when you select Edit from the Query pull-down menu.

Fields

•Connection alias

•Access set

•Query name

•Description

•Show SQL

Menu-bar choices

•Query

•Options

Push buttons

•Select OK to accept and validate the values, and close the window.

•Select Show SQL to display the SQL statement you have specified.