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

Problems with Search Criteria

rbuserrbuser
edited July 2007 in End User
?Hi,

I use RBuilder 7.04 with Delphi5 and occur an error when loading a
report that is stored in a database (Informix).

"TdaMetaCache.GetFields: unable to find table xxxxxx in cache."

This only happens if I to use Search Criterias in report.
In case that it does not use, report is shown without problems.

How can I solve this?



--- posted by geoForum on http://delphi.newswhat.com

Comments

  • nardmoseleynardmoseley
    edited July 2007

    We have not used Informix, but some databases, such as Oracle, require that
    the table name be prefixed with the owner/schema name. When that is the
    case, use the TppDataDictionary and set DataDictionary.UseTableOwnerName to
    true.

    Try creating a new report and adding search criteria and see whether it
    results in the same error.

    ReportBuilder uses TdaMetaCache to cache information about the list of
    available tables and fields in the database that are you using.

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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.