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: 2908
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

Posts: 214
Joined: Mon 29 Jan 2007 08:03

Re: TMSQuery local update

Post by kaffeburk » Sun 16 Feb 2020 23:27

Links are boken.

Devart Team
Posts: 382
Joined: Tue 03 Oct 2017 11:00

Re: TMSQuery local update

Post by Stellar » Mon 24 Feb 2020 10:36

Thank you for the information. We've updated the links to our online documentation.

Post Reply