Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

New table in database.

edited February 2011 in DADE
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

Comments

  • edited February 2011
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited February 2011
    Is there no way to do this in designmode?

    Terje

  • edited February 2011
    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


  • edited February 2011
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited February 2011
    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


This discussion has been closed.