Sun
ONE Active Server Pages Product Home Page Developer Site Version
 

ContentsPreviousNextIndex



ADO Parameter Object Direction Property

Indicates whether the Parameter object represents an input parameter, an output parameter, or both, or if the parameter is the return value from a stored procedure.

Direction Property Return Values

Sets or returns one of the following ParameterDirectionEnum values

Constant
Description
AdParamInput
Default. Indicates an input parameter.
AdParamOutput
Indicates an output parameter.
AdParamInputOutput
Indicates a two-way parameter.
AdParamReturnValue
Indicates a return value.

Direction Property 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 do not return this information, or to set this information when you do not 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.



ContentsPreviousNextIndex