Master / Detail/ CachedUpdates / tiReadCommitted
Posted: 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.
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.