[thelist] Calling a sproc from VB

Scott Dexter dexilalolai at yahoo.com
Thu Feb 5 11:12:27 CST 2004

> sSprocReturn = cmd.Execute

cmd.Execute returns a recordset; you can do something

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

and in the vb--

set rsResult = cmd.Execute
reval = rsResult(0)


More information about the thelist mailing list