Forum Discussion

blearyeye's avatar
blearyeye
Contributor
14 years ago

Using ParamByName with ADO.CreateAdoStoredProc()

I have a TC function that uses an SQL server stored procedure; see below. It bombs on the ParamByName line. I've tried the name with and without the @. When I omit the line, it complains (correctly) t...
blearyeye's avatar
blearyeye
Contributor
14 years ago
Ah, of course. But I don't see where this use of CreateParameter is documented. Can you give a pointer?



 
qry.Parameters.CreateParameter("InstanceNumber", adInteger,
adParamInput, 0, instanceNumber)