Devart Forums

Hi,


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




thnx,

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

Links are boken.

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