New table in database.

rbuser

Hi,

I have a new table in my MS-sqlserver database. How can i refresh reports so
this new table can be visible in the datatab of existing reports?

Regards,
Terje Syversen

nicocizik

Hi Terje,

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

Is there no way to do this in designmode?

Terje

rbuser

I probably should explain this better. I have a TReport on a form and the
DataPipeline is a daADOQueryDataView. I have tried this
gMetaDataManager.Clear, but that dit nothing. Where do i put this line to
get it to work? As the report is compiled into the application i need to do
this at designtime to include this new table into the report. Do i have to
create this report from scratch to get to this new table? There should be a
"refresh" button on the datatab to solve this. I probably not the first
developer that creates a new table and need to get this into a existing
report. Have i missed some easy solution for this?

Best regards,
Terje

nicocizik

Hi Terje,

Are you using the DataDictionary? If so, have you refreshed its table
values?



Regards,

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

rbuser

Hi Nico,

I am not using DataDictionary. The problem solved itself in some strange
way, because of a restart of the computer maybe. The table was available in
the report when i opened it in designmode (in Delphi IDE) today. You should
consider a refresh-button on the table-tab of the query-designer. Thanks for
your effort.

Regards,
Terje