TECH TIP: Troubleshooting TdaMetache Errors Issue Running a report and/or acessing the Query tools, results in the following error… Error: TdaMetacache.GetFields unable to find table ‘tablename’ in cache” Solution This error indicates an issue with the database connectivity settings for either the Query tools or the report’s DataViews. The Designer’s DataSettings are used to specify  Full Article…

Question “Is is possible to use the DataDictionary Builder at run-time?” Solution The following example shows how to create the DataDictionary Builder via code. Download: DataDictionaryBuilderAtRunTime.zip Delphi code sample: uses daDataDictionaryBuilder; procedure TForm1.Button1Click(Sender: TObject); var lForm: TdaDataDictionaryBuilderForm; begin lForm := TdaDataDictionaryBuilderForm.Create(Application); lForm.DataDictionary := ppDataDictionary1; if lForm.ValidSettings then lForm.Show else stbStatus.SimpleText := lForm.ErrorMessage; end;  

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;