Master / Detail/ CachedUpdates / tiReadCommitted

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

Moderators: gto, cipto_kh, EgonHugeist, mdaems

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

Master / Detail/ CachedUpdates / tiReadCommitted

Postby ludviggf » 22.10.2008, 13:27

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

Postby ludviggf » 28.10.2008, 13:14

Anybody have any idea about it?


Return to “User Contributions”

Who is online

Users browsing this forum: No registered users and 1 guest