ADO Direction Property
The Direction property sets or returns a ParameterDirectionEnum value
that specifies how a parameter is passed to or from a procedure. Default
value is adParamInput.
Is it an input parameter, an output parameter, an input and an output
parameter, or a return value from a procedure?
Syntax
Example
set comm=New ADODB.Command
set para=New ADODB.Parameter
para.Type=adVarChar
para.Size=25
para.Direction=adParamInput
para.Value=varfname
comm.Parameters.Append para
|
ParameterDirectionEnum Values
|
Constant |
Value |
Description |
| adParamUnknown |
0 |
Direction unknown |
| adParamInput |
1 |
Default. Input parameter |
| adParamInputOutput |
3 |
Input and output parameter |
| adParamOutput |
2 |
Output parameter |
| adParamReturnValue |
4 |
Return value |
|