[thelist] Calling a sproc from VB

[Scott Dexter]

> sSprocReturn = cmd.Execute

cmd.Execute returns a recordset; you can do something
like:

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

and in the vb--

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


sgd