TFDMemTable CachedUpdates and Remote Data Synchronization

The TFDMemTable component in Delphi is often used to decouple the UI from the database by mirroring remote data in memory. When the CachedUpdates property is enabled, changes are queued locally to minimize server round-trips.

A challenge arises when the underlying database is modified by external processes while the TFDMemTable holds pending local updates. Because the component lacks a native mechanism to merge remote changes into the local cache without overwriting uncommitted local edits, there is a risk of data inconsistency or lost updates during the synchronization process.

• How can TFDMemTable be configured to detect remote changes without flushing the local CachedUpdates queue?
• Is there a documented strategy to merge external database updates into a TFDMemTable while preserving pending local modifications?