TMSQuery local update

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 7
Joined: Tue 15 Mar 2016 20:05

TMSQuery local update

Post by nijazicitaku » Sun 19 Jun 2016 15:32


is there anyway to update MSQuery localy, something like FireDac Localsql?


Devart Team
Posts: 2299
Joined: Wed 30 Jul 2014 07:16

Re: TMSQuery local update

Post by ViktorV » Mon 20 Jun 2016 07:38

For local data update using TMSQuery component, you can use the CachedUpdates or LocalUpdate modes.
In the CachedUpdates mode all changes are stored in the dataset buffer. So you can call the ApplyUpdates method later to send the changes to the database.
In the LocalUpdate mode data in dataset are changed locally but information about changes is not stored. So you cannot send the changes to the database.
For more information about these modes, please refer to SDAC help: ... pdates.htm, ... update.htm

Post Reply