Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oller283
Starting Member
3 Posts |
 Posted - 2000-11-15 : 08:46:11
|
| I need to be able to return values from stored procedures that also can return recordsets. There are a few options for this, but I haven't managed to get a single one of them to work: 1) OUTPUT ParametersThe problem is that OUTPUT arguments to stored procedures can not (with ADODB) be read before the recordset is closed2) Return values (through the return statement)Can not (with ADODB) be read before the recordset is closed. 3) Use two recordsetsAnother option is to return two recordsets, one with the data and one with the return value. Similar problem here, error recordset should be the first in the collection (because I want return value before proceeding). But I usually don't know about the return value before having processed/retrieved the data.4) The raiserror statementYet another option is to use Raiserror. I've tried to find the error from the Connection.Errors collection. But it is empty.What do I do?/O |
|
|
|
|
|
Return values from stored procedures in asp