Parameters Tab (Recordset Properties Dialog Box)

See Also      Tasks

Sets parameter values for a stored procedure contained in the Recordset design-time control. These settings also apply to parameterized queries.

Options

Values for parameters

Type

Displays the parameter type:

• In   The stored procedure parameter value is sent to the database
  
  
• In/Out   The parameter value can be both sent and returned.

This setting is read-only.

Parameter name

Displays the parameter name. This setting is read-only.

Data type

Displays the parameter's data type. This setting is read-only.

Size

Displays the parameter's size. This setting is read-only.

Req

This setting is checked if the parameter is required for the stored procedure. This setting is read-only.

Value

Enter the value you want to use for the parameter. The value must be of the correct data type and size. The value must be able to be evaluated at run time.

If you are using a variable, that variable's value must be set prior to opening the recordset; alternately you can use constants or request objects.