multiple recordsets and errors in MSSQL stored procedure

Thread View: borland.public.cppbuilder.database.ado

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by vavan Thu, 08 Feb 2001 08:39

#5771

Author: vavan
Date: Thu, 08 Feb 2001 08:39

14 lines
1672 bytes

In MSSQL 7 I have the stored procedure that returns multiple recordsets.

select FirstValue
raiserror("message",10,1)
select SecondValue
return

In my application written in Borland C++ Builder 5 on client side I can skip
message returned between two recordsets doing NextRecordset method. But if I
change severity from 10 to 11 in the stored procedure I get an exception
"message" as expected after first NextRecordset and I cannot retrieve the
second recordset because the following NextRecordset returns null though in
Query Analyzer I can see both recordsets and error message between them. Is
it ADO design or my mistake?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads