output parameters and output recordsets
Yeah, that's what I had, but was having some freaky-freaky problem with
JScript (?) and this.
Basically, I was calling the function in question from an exception handler.
In the try of that block, I was executing another stored proc which had
returned a unique constraint violation. If I try to reuse the same
connection object, I get one of a few errors such as:
* Used "EXEC" so output parameters were not returned (paraphrase)
* You can't use a server cursor for sp's that return multiple recordsets,
try a client cursor (which I was)
If I create a new connection object it worked fine. See, freaky-freaky.
Quote:
> Max - Like this?
> create proc testproc
> as
> select au_lname from authors
> select * from authors
> HTH
> Jerry
> >Is it possible to have a procedure that has output parameters AND returns
> >rows? I'm getting an error using ADO and trying to do this, but not sure
> if
> >it's my fault or just not possible.
> >Thanks.
