🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

TADOConnection->BeginTrans, CommitTrans, RollBackTrans problem

#5232
From: Peter Falconer
Date: Sun, 24 Jun 2001 21:23
32 lines
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!dnews

Show 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