Direction Property
Indicates whether the Parameter represents an
input parameter, an output parameter, or both, or if the parameter is the
return value from a stored procedure.
Settings and Return Values
Sets or returns one of the following ParameterDirectionEnum values:
|
Constant
|
Value
|
Description
|
|
adParamInput
|
1
|
Input parameter. (Default.)
|
|
adParamOutput
|
2
|
Output parameter.
|
|
adParamInputOutput
|
3
|
Input and output parameter.
|
|
adParamReturnValue
|
4
|
Return value.
|
Remarks
Use the Direction property to specify how a parameter is passed to or
from a procedure. The Direction property is read/write; this allows you
to work with providers that don't return this information or to set this
information when you don't want ADO to make an extra call to the provider
to retrieve parameter information.
Not all providers can determine the direction of parameters in their stored
procedures. In these cases, you must set the Direction property prior
to executing the query.
Applies To
Parameter
| 
