open a recordset and pass parameter to stored proc -- is it possible?

[automicgina]

I have a stored proc that takes a parameter from the program and return a set of data. I can pass the parameter using ADODB.Command, but not ADODB.Recordset (there's no option to pass parameter). Is it even possible? If not, what's the better way to do it?

 

[Guest_imported]

i believe you can do this:

dim cmd as new Command
dim rs as new RecordSet

set cmd.activeconnection = cnMyConnection
cmd.commandtype = adcmdstoredproc
cmd.commandtext = "myProc" ' name of stored proc
....
' set up parameters collection
....

rs.open cmd

hope this helps

 

[vb5prgrmr]

see thread222-335550