The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
Senior Boarder
Senior Boarder
Posts: 95
Joined: 13.05.2010, 18:48


Postby sfxcc » 03.11.2013, 16:13

I have a masterTable and a detail table on postgresql, i need to inset mastertable line and the the details lines.

How can i do this two tables if on fail rollback ? cached updates is for own table how can i do both be on same commit ?

This to avoid convert tables to sql text because then work ... any change to be with zquery components?
where's the code ..

User avatar
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Re: Transactions

Postby EgonHugeist » 04.11.2013, 21:43

Hi Sergio,

Use ChachedUpdates for the TZDataSet descendants. TZConnection.AutoCommit schould be False.

Than use the TZDataSet.Options := TZDataSet.Options + [doUpdateMasterFirst].
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude!


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest