Data Block Wizard: Query page
To select a QUERY procedure:
- On the Query page, in the Procedure field, enter the name of the procedure
that will retrieve information for the data block.
- 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:
- Select the column.
- 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.
- When you move a column from the Available Columns list to the Database
Items list, if the item:
- does not already exist in the data block, the wizard will create a
new item and set its Database Item property to Yes.
- already exists in the data block, the wizard automatically will set
the item's Database Item property to Yes.
- 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:
- Select the column.
- Drag-and-drop the column to the Database Items
list or click the left arrow or the double left arrow.
- When you move a column from the Database Items
list to the Available Columns list, if the item:
- does not already exist in the data block, no item based on the column
will appear in the data block.
- already exists in the data block, the item will remain in the data
block, but the wizard automatically will set the item's Database Item
property to No.
To specify a value for an argument:
- Enter it in the Value field.