Page 1 of 1

Master / Detail/ CachedUpdates / tiReadCommitted

Posted: 22.10.2008, 13:27
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.

Posted: 28.10.2008, 13:14
by ludviggf
Anybody have any idea about it?