The Data Window preference variable stored_procedure_build determines how the result set of a DataWindow using a stored procedure gets generated.

When the variable is set to 1 (the default), you are not prompted for the result set description when you select stored procedure as the data source for a DataWindow or report. When stored_procedure_build is 1, the procedure is executed and the result set description is built automatically. To edit the description, click the SQL Select icon or select Edit Data Source from the Design menu.

Tip       To see the syntax for the stored procedure in the Select Stored Procedure dialog, click the More button.

To define arguments for the stored procedure, click the Arguments button. The Specify Retrieval Arguments dialog displays. To select another procedure, click the Procedures button. The Select Procedure dialog displays.