Refreshing the table cache

rbuser

The database we're using has *MANY* tables, so loading all the table and
field information takes a very long time. Therefore we want the table
cache to only load information about the tables it needs.

How?


So far...
I can update the filter in the OnBeforeQuery event in the dataset
components that load table and field information.

From what I can see, the 1st line in TdaMetaData.GetTables() checks to
see if the cache already is populated. Aside from editing that method,
is there another way (in our own code) to force a reaload of the cache?



--- posted by geoForum on http://delphi.newswhat.com

nardmoseley

----------------------------------------
Tech Tip: Clearing the Meta Data Cache
----------------------------------------

There is a global meta data cache that the ReportBuilder uses to cache
information about the available database tables and fields. You can clear
the meta data cache using the following code.

uses
daMetaDataManager;

begin
gMetaDataManager.Clear;

end;

--
Tech Support mailto:support@digital-metaphors.com
Digital Metaphors http://www.digital-metaphors.com

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Thanks. That works nicely.



--- posted by geoForum on http://delphi.newswhat.com