Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Query Wizard 'Unable to find table in cache'

rbuserrbuser
edited January 2005 in End User
Hi,

I've got the following problem:

One first run the tables are created with an SQL query and then data is
imported from txt files.

When the user starts report explorer is launched and the user can create a
new report. But when I go to the data tab and run the Query Wizzard I get
the following error when I select a table and hit finish:

---------------------------
Debugger Exception Notification
---------------------------
Project Import.exe raised exception class EDesignError with message
'TdaMetaCache.GetFields: unable to find table Client in cache.'. Process
stopped. Use Step or Run to continue.
---------------------------
OK Help
---------------------------

It used to work but suddenly this error appears and I don't think I've
changed something so I have no clue why this happens.

I'm using DBISAM 4.15, ReportBuilder 7.04 and Delphi 7.0

Thnx for your help

Comments

  • nardmoseleynardmoseley
    edited January 2005

    1. DADE is designed to be used with a single database at time. If you modify
    the database connection, then you need to clear the internal meta cache.
    (The meta cache contains information about the tables and fields in the
    database). See Tech Tip article below.

    2. The Designer.DataSettings that are used to create the report are saved as
    part of the query definition. When an existing query is loaded, the
    DatabaseName value is used to find a DBISAMDatabase component with the same
    name. Make sure that you consistently use the same name.


    ----------------------------------------
    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;

    --
    Tech Support mailto:support@digital-metaphors.com
    Digital Metaphors http://www.digital-metaphors.com


    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited January 2005
    "Nard Moseley (Digital Metaphors)" schreef
  • nardmoseleynardmoseley
    edited January 2005

    1. Try clearing the DataDictionary tables and regenerating them.

    2. Next, check the TppDesigner.Datasettings.

    3. Now run the project and try creating some new reports that contain
    queries on those tables.

    There are no known issues with RB EndUser and DBISAM. We have many customers
    using DBISAM.

    If you still have an issue, try the RBuilder\Demos\EndUser Databases\DBISAM
    example.

    If that does not work, then create a simple Delphi example project - use the
    RBuilder\Demos\EndUser Databases\DBISAM example and then send it to
    support@digital-metaphors.com along with the data. We can try to check it
    out here.



    --
    Nard Moseley
    Digital Metaphors Corporation
    www.digital-metaphors.com



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited January 2005
    "Nard Moseley (Digital Metaphors)" schreef
This discussion has been closed.