Microsoft ActiveX Data ObjectsMicrosoft ActiveX Data Objects*
*Contents  *Index  *Topic Contents

Direction Property - ADO

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.

Applies To

Parameter

Settings and 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 both an input and output parameter.
adParamReturnValue Indicates a 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.

Examples

ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example (VB)

Up Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.