multiple recordsets and errors in MSSQL stored procedure

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

Article #5771

Back to borland.public.cppbuilder.database.ado Previous Next

#5771

From: 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?

Technical Details

Message-ID: <3a83bee3_2@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.stealth.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!195.170.216.131

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f5cad,7076a7549f2d09b9,start
X-Google-Attributes: gidf5cad,public
X-Google-Thread: 10698b,7076a7549f2d09b9,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-02-09 02:01:34 PST
From: "vavan" <vavan@santel.ru>
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.delphi.database.ado
Subject: multiple recordsets and errors in MSSQL stored procedure
Date: Thu, 8 Feb 2001 11:39:42 +0300
Lines: 16
Organization: TAIF-TELCOM
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 195.170.216.131
Message-ID: <3a83bee3_2@dnews>
X-Trace: 9 Feb 2001 01:56:51 -0800, 195.170.216.131
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.stealth.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!195.170.216.131