[thelist] capturing returned value from MS-SQL stored procedure
Scott Dexter
sgd at ti3.com
Thu Jan 10 18:08:46 CST 2002
instead of an output parameter, do something like
Select @RetVal as PonID
return
as you exit the stored proc. That will return a recordset back to the
caller...
sgd
--
work: http://ti3.com/
non: http://thinksafely.org/
> -----Original Message-----
> From: spinhead [mailto:evolt at spinhead.com]
>
> Gladly. Any suggestions? I'm not fussy about method, just
> results. What I'm
> trying to do is avoid making two sequential calls to the db,
> one to insert,
> then going back to read the max value.
More information about the thelist
mailing list