Switching database does not update tables available in the Query Wizard

rbuser

Hi again

I've another silly problem that hopefully should be easy to remedy.

I'm switching DBase databases before I execute the report designer via

ADOConnection.Close;
ADOConnection.ConnectionString := MyConnectionStr;
ADOConnection.Open;
with ppReportExplorer1.Designer.DataSettings do
begin
SessionType := 'ADOSession';
DatabaseName := 'ADOConnection';
DatabaseType := dtOther;
SQLType := sqSQL1;
end;

I can create a new report and in the data tab / query wizard I can see my
tables...so far so good

I then cancel the report and then switch to another dbase database using a
different connection string and then create another report. Going to the
Query Wizard again, I see the tables from the previous connection still?

How to I reset the Report designer so that if refreshes the tablelist with
the tables from the new connection?

I've tried closing the data dicationary compoent but that doesn't seem to
make much of a difference.
I've managed to replicate the same problem by modifying the EndUser demo to
work the same way so I'm pretty sure it's something I'm doing wrong!

Thanks again for your assistance,


Chris Hedges

nicocizik

Hi Chris,

ReportBuilder caches the table and field information to improve performance
while designing and manipulating queries in DADE. Take a look at the
following article on clearing the metadata cache.

http://www.digital-metaphors.com/rbWiki/DADE/MetaData/Clear_MetaData

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks Nico,

That works perfectly.