Article View: borland.public.cppbuilder.database.ado
Article #5232TADOConnection->BeginTrans, CommitTrans, RollBackTrans problem
From: Peter Falconer
Date: Sun, 24 Jun 2001 21:23
Date: Sun, 24 Jun 2001 21:23
32 lines
1849 bytes
1849 bytes
G'day,
I'm using Builder 5 Enterprise version on a MS SQL Server7 db.
I'm running code as follows
MyADOConnection->BeginTrans();
//display a form to collect info and do various things
if (MyDialog->ShowModal() == mrOk)
{
MyADOConnection->CommitTrans();
}
else
{
MyADOConnection->RollbackTrans();
}
The first time this code is executed all seems well, but if I
immediately repeat it I get
a "Catastrophic Error" reported, the computer begins to smoke, all the
alarms in the building go off, my wife leaves me and I develop cancer.
(I assume this is why I get "Catastrophic error", rather than "An
error occurred". Frankly, I would have been happy to just get "An
error occurred" as those alarms are terribly annoying.)
Is this a bug or have I done something silly with the connection? I'd
supply more details but I'm not sure which details might be relevant.
Does anyone have any clues?
Thanks,
Peter
Technical Details
Message-ID:
<3b3659c6_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,24371f11b2085ee,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-06-24 14:40:16 PST From: "Peter Falconer" <Peter.Falconer@fsunion.org.au> Newsgroups: borland.public.cppbuilder.database.ado Subject: TADOConnection->BeginTrans, CommitTrans, RollBackTrans problem Date: Mon, 25 Jun 2001 07:23:59 +1000 Lines: 33 Organization: FSU MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Newsreader: Microsoft Outlook Express 4.72.3612.1700 X-Mimeole: Produced By Microsoft MimeOLE V4.72.3612.1700 NNTP-Posting-Host: 203.55.24.2 Message-ID: <3b3659c6_1@dnews> X-Trace: dnews 993417670 203.55.24.2 (24 Jun 2001 14:21:10 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews