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

Data Block Wizard: Query page

To select a QUERY procedure:

  1. On the Query page, in the Procedure field, enter the name of the procedure that will retrieve information for the data block.
  2. Click Refresh.
    If you are not connected to a database, the wizard displays the Connect dialog.

To map a column from the stored procedure to a database item in the data block:

  1. Select the column.
  2. Drag-and-drop the column or click the right arrow to move the selected column(s) from the Available Columns list to the Database Items list.
  3. When you move a column from the Available Columns list to the Database Items list, if the item:
  4. To move all available columns, click the double right arrow.
    Hint: Be sure to map all primary-key and other mandatory columns from the stored procedure to items in the data block.

To move a column out of the data block:

  1. Select the column.
  2. Drag-and-drop the column to the Database Items list or click the left arrow or the double left arrow.
  3. When you move a column from the Database Items list to the Available Columns list, if the item:

To specify a value for an argument: