X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY ANGULAR XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

ADO Direction Property


Parameter Object Reference Complete Parameter Object Reference

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

objparameter.Direction

Example

<%
set comm=Server.CreateObject("ADODB.Command")
set para=Server.CreateObject("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


Parameter Object Reference Complete Parameter Object Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB HOSTING

UK Reseller Hosting

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates FREE Website Templates Free HTML Templates

SHARE THIS PAGE

facebook