Using Store Procedures in VB

[TrevorUbi]

Hi

I have created a store procedure in SQL 2000 that contains 7 varibales to be passed to it. The store procedure does not return any information.

In VB, I am using ado commands.

How is the best way I can pass the seven parameters from VB to the Store procedure. Am I right in thinking that I need to use the commandtype = adcmdstoredproc command?

Any help would be grateful.

Trevor

 

[nigelrivett]

see

http://www.nigelrivett.net/VB6DataAccessLayer.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.