Stored Procedure Parameter Property Builder dialog box

Build and maintain the parameters used in stored procedures.

The Parameter Name box lists all the parameters used with a specific stored procedure object. Click on a parameter name to display the parameter’s type (in the Parameter Type field) and the parameter value’s data type and value (in the Parameter Value field).

Dialog box options

Parameter name

Lists all the parameters used with a specific stored procedure object. Click on a parameter name to display the parameter value’s data type and value in the Parameter Value box.

Data type

Displays the type of the parameter entered in the Parameter Name box. The parameter can be one of four types:

1. Input

• Output

• Input/Output

• Result

Value

Displays the value of the parameter entered in the Parameter Name box.

How to get there: In the Inspector, select the StoredProc object. Then, click the wrench tool beside the params property.