Devart Forums

Mydav 3.55 - Delphi 5
Mytable ART: InnoDB Cache Update = true
How can I refresh the records on other machines?
Thanks

Use the TDataSet.Refresh method.

Thanks for your reply.
Running Tdataset.Refresh is possible that the cache is lost?
My problem is this:
pc1-> ART.append-> id = X -> applyupdate-> commit, etc.. etc. ..
pc2-> ART.LOCATE (X) -> record not found
Thanks

If you call the Refresh method all modified cached data will be lost. To solve this problem you should save data to the database by calling the ApplyUpdates and Commit methods.

Thanks Dimon
Take this opportunity to ask you if you want to use the cacheupdate all transactions?
Are sufficient only transactions without cacheupdate?
Thanks again
Hello

Using the cached updates mode and transactions are not connected.

Cached updates are especially useful for client applications working with remote database servers. Enabling cached updates brings up the following benefits:
- Fewer access counts to database and shorter session times.
- Minimized network traffic.

Transactions are used to commit or rollback many changes in database at a heat. Updates, insertions, and deletions that take place after a call of StartTransaction are held by the server until application calls Commit to save the changes, or Rollback to cancel them.

You can find more detailed information about this in the MyDAC help.