ADO Error

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

Article #4774

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

#4774

From: Dale
Date: Thu, 18 Oct 2001 20:27

17 lines
1338 bytes

I run a Stored proc.  It is does an insert.  If it throws a key violation I
try and return a code in a select

SELECT @Returncode

I have SET NOCOUNT ON

Using and older MDAC I could just grab this off the returned Dataset.  I
installed MDAC 2.6,  the BCB Upgrade and the ADOExpress upgrade, and this
stopped working somewhere.

Does anyone have another way to select back a resultset after an error has
been returned.

thanks

Dale

Technical Details

Message-ID: <3bcf3b50$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,813b5ae544a1f3b1,start
X-Google-Attributes: gid10698b,public
X-Google-Thread: f5cad,813b5ae544a1f3b1,start
X-Google-Attributes: gidf5cad,public
X-Google-ArrivalTime: 2001-10-18 13:31:37 PST
From: "Dale" <Dkrebbers@cenadex.com>
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.delphi.database.ado
Subject: ADO Error
Date: Thu, 18 Oct 2001 13:27:42 -0700
Lines: 21
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: 24.67.186.198
Message-ID: <3bcf3b50$1_1@dnews>
X-Trace: dnews 1003436880 24.67.186.198 (18 Oct 2001 13:28:00 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews