ADO error handling

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

Article #5842

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

#5842

From: vavan
Date: Wed, 31 Jan 2001 12:51

20 lines
1807 bytes

Here's snippet from simple stored procedure in MSSQL7:

RaisError('Message',10,1)
select SomePredefinedValue
return

If I run that sp using TADOStroredProc on my AppServer I can see
SomePredefinedValue in the grid on the client side. But if I change severity
code (the second parameter in raiserror) from 10 to 11 it throws an
exception 'Message' on client side and no result are shown in the grid. That
exception happens in ADODB.PAS TCustomADODataSet.OpenCursor on the following
line:

Recordset.Open(Source, ActiveConnection,CursorTypeValues[FCursorType],
LockTypeValues[FLockType],CommandTypeValues[CommandType] +
ExecuteOptionsToOrd(ExecuteOptions));

But if I run that sp within the SQL Profiler then I can see both error
message and resultset. Is there a way to suppress or ignore that error
message and show resultset anyway?

Technical Details

Message-ID: <3a780cfd_1@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-01!supernews.com!feeder.qis.net!sunqbc.risq.qc.ca!nntp1.njy.teleglobe.net!teleglobe.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: 10698b,ddc0cb220b5d66f3,start
X-Google-Attributes: gid10698b,public
X-Google-Thread: f5cad,ddc0cb220b5d66f3,start
X-Google-Attributes: gidf5cad,public
X-Google-ArrivalTime: 2001-01-31 05:03:57 PST
From: "vavan" <vavan@santel.ru>
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.delphi.database.ado
Subject: ADO error handling
Date: Wed, 31 Jan 2001 15:51:45 +0300
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 195.170.216.131
Message-ID: <3a780cfd_1@dnews>
X-Trace: 31 Jan 2001 05:02:53 -0800, 195.170.216.131
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-01!supernews.com!feeder.qis.net!sunqbc.risq.qc.ca!nntp1.njy.teleglobe.net!teleglobe.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!195.170.216.131