Editing database statements

If required, then you can make text edits to database statements. Select the type of database statement by clicking SQL or Stored Procedure. Both of these open the Stored Procedure Out Parameters dialog box.

This dialog box has these checkboxes where you can define the expected return from the stored procedure:

  • Return Code
  • Out Parameters

One of these must be selected. All are selected by default.

Result Set is optional. Sometimes, a result set is returned by a stored procedure. To use this in Out Parameters, specify the column names separated by a comma. Otherwise, if the result set is not required, you can leave the field blank.