Master / Detail/ CachedUpdates / tiReadCommitted

Code samples and contributions from users for ZeosLib's DBOs of version 6.x

Moderators: gto, cipto_kh, EgonHugeist, mdaems

Post Reply
ludviggf
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 18.10.2008, 00:39

Master / Detail/ CachedUpdates / tiReadCommitted

Post by ludviggf »

I have the following case:
Connection -> TransactIsolationLevel = tiReadCommitted
Master - CachedUpdates = True
Detail -> CachedUpdates = True

When I click the post button:


Connection.StartTransaction
try
Master.ApplyUpdates
Detail.ApplyUpdates
1 record applies
1 record occurs error
except
Connection.Rollback
Master.Edit
raise
End
Connection.Commit

Error: if you try to write again I will miss the first record
detail table because the UpdateType changed to utUnmodified

I need all records of the Master / Detail remain
with the same UpdateType that can be applied to all again.

Excuse my English, writing from Brazil.
ludviggf
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 18.10.2008, 00:39

Post by ludviggf »

Anybody have any idea about it?
Post Reply