Devart Forums

I have a situation where the query.cachedupdates = true;

I am using the version Odac 6.50.0.39 (professional) with delphi7.

For simullation situation you make,

1) Open query with empty records in database

2-Insert one row and post and applyupdates = success insert in database
2-Insert one row and post and applyupdates = sucess insert in database
3-Insert one row and post and applyupdates = sucess insert in database
4-move cursor last row (3)
5-Delete row number 3, and applyupdates = not action delete on database and UpdatesPending = false
6-Delete row number 2, and applyupdates = again, not action delete on database and UpdatesPending = false

For the that can identify the lines excluded that you/they were inserted with cachedupdate=true same that applied in the database, they are not excluded while it doesn't happen a refresh in the query

respectfully

Vanderlei

You should call CommitUpdates after each call to ApplyUpdates to clear the cached updates buffer.