Question “Our end-user reporting solution needs to implement a security scheme to limit the data that is available to end-users.” Solution Use the DataDictionary to limit which tables and fields are available to end-users. To limit specific table records that are accessible requires that you modify the SQL statement submitted to the database. The best Full Article…
Search the Wiki
TdaMetaCache Errors
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…
How To…Use the DataDictionary Builder at Run-Time
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;