Transactions

[sfxcc]

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?

[EgonHugeist]

Hi Sergio,

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

Than use the TZDataSet.Options := TZDataSet.Options + [doUpdateMasterFirst].