Page 1 of 1

Use UniQuery/UniDataSource local

Posted: Tue 15 Nov 2016 09:13
by norwegen60
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

Re: Use UniQuery/UniDataSource local

Posted: Tue 15 Nov 2016 09:47
by ViktorV
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