[thelist] Calling a sproc from VB

Ken Schaefer ken at adOpenStatic.com
Thu Feb 5 17:46:39 CST 2004


Have you thought about going and looking in an ADO reference? Then you'd
know what objCommand.Execute returns (hint: not a return value), and you'd
know how to get it.

If you need some code, here is an example:


From: "Tab Alleman" <Tab.Alleman at MetroGuide.com>
Subject: RE: [thelist] Calling a sproc from VB

Scott Dexter wrote:

>  in stored proc--
> // last line
> Select @retval as 'ReturnVal'

There's no way VB can access the value of a sproc's

RETURN SomeValue


More information about the thelist mailing list