Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
passing parameters
- Thread starter EscapeUK
- Start date
You use the Command Object in ADO.
Parameters are added via use of the Parameters collections.
The above example calls a Stored Procedure that has one parameter of type integer that is an input parameter. The last parameter in CreateParameter method is the value to be passed to the Parameter in the stored procedure.
James
James Culshaw
jculshaw@active-data-solutions.co.uk
Parameters are added via use of the Parameters collections.
Code:
set cmInsert = New ADODB.Command
cmInsert.CommandType = adStoredProc
cmInsert.CommandText = "StoredProcName"
cmInsert.Parameters.Append cmInsert.CreateParameter("ParamName", adInteger, adParamInput,,110)
cmInsert.ExecuteThe above example calls a Stored Procedure that has one parameter of type integer that is an input parameter. The last parameter in CreateParameter method is the value to be passed to the Parameter in the stored procedure.
James
James Culshawjculshaw@active-data-solutions.co.uk
- Status
Similar threads
