Re: OO4O Transactions: Updates not being rolled=back

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sun, 24 Sep 2006 14:54:46 +0100
Message-ID: <r7SdnU-yZKO6E4vYnZ2dnUVZ8qSdnZ2d@pipex.net>

CJM wrote:
> I'm using OO4O via ASP to manipulate an Oracle 10g database (v10.1.0.4).
>
> At the start of each vbScript section I'm starting off the transaction as
> follows:
>
> oDB.AutoCommit = False
> oDB.BeginTrans
>
> And at the end of the section, I have the following:
>
> If iError > 0 then
> oDB.RollbackTrans
> Else
> oDB.CommitTrans
> End If
>
> Pretty simple... but unfortunately it doesnt work.
>
> All the help I can find only points to this code being correct... where am I
> going wrong?
>
> CJM
>
>

Can you show the full code? Have you checked the value of iError?

-- 

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/

Received on Sun Sep 24 2006 - 08:54:46 CDT