variable

B

Brian

The way I know how would be to create a Command object
with an Output parameter that calls your stored
procedure. After the Command executes you can access the
parameter setting your variable equal to the Parameter
value of the Command object like this:

myVar = cmdCallProc(0)

Where zero is the index of the Output parameter if that's
the only parameter you have added to the Command object.

Hope this helps

Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top