A script-enabled browser is required for this page to function properly.

LOV Wizard: SQL Query Page

LOV Wizard: Column Selection page

Use this page to specify the SQL query that will be used to construct the record group on which the LOV will be based. This page is displayed only when a new LOV is being created.

If you selected an existing record group on the LOV Source page, or if you are using the wizard in re-entrant mode, the text field on this page will already contain the SQL query on which the selected record group is based.

To specify or modify the SQL query:

  1. To enter the query directly, type the appropriate SQL code directly into the text field in the middle of the page.
  2. To import a SQL query from a file, click the Import SQL Query button.

To check the syntax of the SQL query in the text field:

To connect to the database:

Note: If on the LOV Source page you choose to base the LOV on an existing static record group, this page will not be displayed, and you will skip automatically to the Column Properties page.