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