Use UniQuery/UniDataSource local

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
norwegen60
Posts: 19
Joined: Wed 15 Dec 2010 13:12

Use UniQuery/UniDataSource local

Post by norwegen60 » Tue 15 Nov 2016 09:13

Hello,

is there a possibility to use TUniQuery/TUniDataSource local. I mean
* Do a select to the database
* Disconnect the Query
* Work with the local data incl. insert new data, but without send it to the database

best regards
Gerd

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Use UniQuery/UniDataSource local

Post by ViktorV » Tue 15 Nov 2016 09:47

For local data update using TUniQuery 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 UniDAC help:
https://www.devart.com/unidac/docs/inde ... pdates.htm
https://www.devart.com/unidac/docs/inde ... update.htm

Post Reply