ReadMeFeed / Community knowledge

#tfdmemtable

Real questions. Useful conversations. Find the people who know your stack.

Question1 answer4,933 followingPosted 18 May 2021, 02:47 UTC52.7K views813 votes

TFDMemTable shows stale rows after external edits to a joined TFDQuery's source tables

Goal: establish when FireDAC invalidates the in-memory buffer of a TFDMemTable populated from a TFDQuery whose SELECT joins several tables, in a Delphi 12 multi-user application. Exact refresh semantics are assumed similar across recent FireDAC releases, but they need checking against the installed version. TFDMemTable is a disconnected in-memory dataset, so

Community & Careers · Editorial question

Community & Careers

Question1 answer1 comment1,659 followingPosted 31 Mar 2020, 03:26 UTC83.1K views1,850 votes

owner answered

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. B

Community & Careers · Editorial question

delphi