manual transaction

Forum related to all 5.x versions of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Delix
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 17.08.2005, 12:19
Location: Lippstadt

manual transaction

Postby Delix » 12.10.2005, 17:06

I will work with manual transactions but there is as Problem:

The following code has been executed and all seems ok.


[syntax="delphi"]
TR0: TZIbSqlTransact;

procedure TMain.Button1Click(Sender: TObject);
begin
TR0.AutoCommit:=False;
TR0.StartTransaction;
..
do_anything..
..
TR0.COMMIT;
TR0.AutoCommit:=True;
end;
[/syntax]

If the Databse should be closed, i get this message:

„cannot disconnect database with open transactions ( 1 active)“

what is wrong?

Michael
ZeosLib's Handyman :o)
ZeosLib's Handyman :o)
Posts: 189
Joined: 15.08.2005, 16:08
Location: Wehrheim
Contact:

Postby Michael » 13.10.2005, 07:47

Hi Delix,

I have no experiences with 5.4.1 but in 6.1.5 these manual transactions are going to work. Just take a look into the examples (Project"Transactions") of our 6.1.5-Tutorial which you may obtain from our download area.

Other question: Did you try this using version 5.5?

Suggestions: If the project is not that big: migrate to 6.1.5. If the project is in planning state: use 6.x.

P.S.: Changed the syntax-highlighting in your post ;-)
:prog2: Use the source, dude!

[align=right]..::.. ZeosLib on SourceForge ..::..[/align]


Return to “5.x Versions”

Who is online

Users browsing this forum: No registered users and 1 guest