Zeos Cannot Commit

Forum related to version 6.1.5 of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
fadhilah
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 15.08.2006, 03:36

Zeos Cannot Commit

Post by fadhilah »

Dear Zeos,
Iam using Zeos 6.1.5(included 2 latest patch), Delphi 7 and Postgresql.
When I edit/add record and then post (and commit also) my change to my postgreql server, it wont updated. My AutoCommit status is 0
Iam Post using ZQuery.Post and Commit using ZQuery.CommitUpdates.

Another case, when i am using Data Control (DBGrid) with same connection and setting, my Post is done but the problem is I haven't do commited yet but change was commited(like I set autocommit=true) but my autocommit is false.

Would you mind to help me

Thank you very much
pol
Senior Boarder
Senior Boarder
Posts: 91
Joined: 13.10.2005, 08:19

Post by pol »

For me it helped to do a ZQuery.ApplyUpdates after the ZQuery.Post, although I didn't use cached updates.
With autocommit try it this way: set it to true, then at the right point issue a StartTransaction (which sets it internally to false, strange enough...) and finally a Commit.

hth
Rüdiger
Post Reply