Subject RE: [IBO] commit ending permanently
Author Kevin Stanton
Hi David,
I just threw a quick project together and can't get your error to happen.

Here's the project info:

Connection component.
Transaction component (ibt) - AutoCommit = True, Isolation = tiCommitted.

select * from customers
order by custname
for update

IB_Datasource and IB Grid.

Button 1: called "Explicit" has the following code:

If NOT ibt.TransactionIsActive then
qryCusts.FieldByName('CustName').AsString := 'ABCXYZ Customer';

Button 2: called "TR AC Status"

If ibt.AutoCommit then
ShowMessage('AutoCommit = True')
ShowMessage('AutoCommit = FALSE');


When I simply change a customer's name, all is well.

When I hit Button 1 and then immediately change the 2nd customer's name in
the list, all works as planned -- the IB Transaction component seems to
automatically go back to "auto-commit" mode.

I'm using IBO Version 4.2.Gb w/ Delphi 6.


-----Original Message-----
From: david_cornelius [mailto:corneliu@...]
Sent: Friday, July 26, 2002 11:12 AM
Subject: [IBO] commit ending permanently

Sorry about the <no subject>...

--- In IBObjects@y..., "david_cornelius" <corneliu@o...> wrote:
> I have an app using a TIB_Transaction with AutoCommit set to true.
> Most of the time, I let AutoCommit take care of the necessary
> transaction handling for me. But for a certain set of operations I
> need to take explicit control, so I call:
> trn.StartTranaction
> <<do some stuff>>
> trn.CommitRetaining
> Then I want to be able to have the same AutoCommit behavior, but
> next operation results in an error: "Invalid Internal
> IB_Transaction". Using CodeSite I notice that, as described in the
> help file, SavePoints are generated for the AutoCommit behavior
> before this, but after I have taken control with the code above and
> done the "CommitRetaining", I see that the transaction has ENDED
> and then I get the error even if I do an explicit StartTransaction
> right after CommitRetaining. Also, any other edits in the app
> get committed to the database.
> How do I get the AutoStart/AutoCommit behavior back again?
> Thanks,
> David Cornelius

Yahoo! Groups Sponsor

IB Objects - direct, complete, custom connectivity to Firebird or
without the need for BDE, ODBC or any other layer.

___________________________________________________________________________ - your IBO community resource for Tech Info
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]