CacheCalcFields is very nice feature to reduce redundant running of onCalcFields or Lookup.
However, there is some case which we need to clear the cache and let the onCalcFields/Lookup to rebuild the cache.
For example, I have many base tables containing name and basic inform for the other tables to lookup for. Regarding the Name fields it is actually a translated text based on the user's current language setting. When the user change language, all the text in name field need to be refresh for the new language. If I do not want to close and re-opened those base tables which unnecessarily reload all data from server, how can I clear the cache and let the tables to refresh all Calc/lookup field?
Thank you in advance for any help.
Is it a way to clear the cache of CacheCalcFields without reloading the data?
Re: Is it a way to clear the cache of CacheCalcFields without reloading the data?
In UniDAC there is no possibility to change the cached values CalcFields in dataset if it is open (TUniQuery.Active=True).