Transactions

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

Transactions

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
EgonHugeist
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! http://sourceforge.net/p/zeoslib/tickets/

Image


Return to “ZeosLib 7.1 stable Forum”

Who is online

Users browsing this forum: No registered users and 1 guest