May 5th, 2003, 07:06 PM
Join Date: Apr 2003
Time spent in forums: < 1 sec
Reputation Power: 0
ADODB Command: Creating Parameters for Stored Procs w/ Parameters
Are there any other way of appending parameters to a command object to be used
in executing a stored proc aside from this one:
1.)cmd.Parameters.Append cmd.CreateParameter("@MyParam1", adLongVarChar, adParamInput, 24, MyValue)
2.) set rst = cmd.Execute , aParams()
where in aParams is a variable that contains data that will be supplied to the stored proc. but
the problem with this one is that I can't create a disconnected recordset. It seems that I cannot
disconnect the recordset if it was populated by a command object
I'm creating a function for executing stored procs to avoid repititive work everytime I need to
execute a stored procs.
Any ideas would be greatly appreciated.