Hi,
is there anyway to update MSQuery localy, something like FireDac Localsql?
thnx,
TMSQuery local update
Re: TMSQuery local update
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: https://www.devart.com/sdac/docs/?devar ... pdates.htm, https://www.devart.com/sdac/docs/?devar ... update.htm
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: https://www.devart.com/sdac/docs/?devar ... pdates.htm, https://www.devart.com/sdac/docs/?devar ... update.htm
Re: TMSQuery local update
Thank you for the information. We've updated the links to our online documentation.