ADO: ActiveX Data Objects

Name

Parameter.Direction Property — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     parameter.Direction = ParameterDirectionEnum
                  

The Direction property specifies whether the current parameter is an input parameter, an output parameter, both an input and an output parameter, or a return value from a stored procedure.

Datatype

ParameterDirectionEnum (Long)

Description

The Direction property is both read- and write-enabled. It is to your advantage to add parameters manually to a Parameters collection so that ADO does not have to make additional calls to the data provider to locate this information itself. In some cases, you must specify the Direction property manually because the particular data provider may not be able to determine this information itself.

The Direction property may be set to one of the ParameterDirectionEnum enumerations listed in Appendix E.

Note

Not all providers can determine the value of the Direction property; therefore, for such providers the application must manually set the value of the Direction property for parameters before they are used.

See Also

ParameterDirectionEnum Enumeration