unable to find table in cache

rbuser

Hi,

I just upgraded from RBuilder 10.04 to 10.06.

Now I get the error "TdaMetaCache.GetFields: unable to find table in
cache." while adding a new table to a query.
I get this error only after I changed the field alias to an existing fields
and I try to add a new table to the query.
I get this problem in my end user solution and in the the IBX EndUser demo
too.

How can I solve this?

Thank you in advance,
Massimiliano Trezzi

nardmoseley

I can successfully run the IBExpress demo that is installed to the
RBuilder\EndUser Databases\Interbase\IBExpress directory.

I don't think anything changed between 10.04 and 10.06 that would affect
this.

Prior to running the demo, configure the database connection and do not
change it thereafter. ReportBuilder caches the table and field information
associated with the database connection.



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

rbuser

I didn't run the demo in 10.04, and I didn't get the error in my end user
solution on that version.
When I upgraded I started to get it with my solution and I tested your end
user solution too, and I got it in both implementations.
As you suggested I changed only the database connection.

To reproduce it use it with emploee.gdb shipped with Interbase 5.6 upgraded
with Rb tables:

* Create a new report
* Go to the data page
* Create a new query with query designer
* Add Country table
* Add all fields of country table
* Change the alias of the field "CURRENCY" to "COUNTRY_CURRENCY"
* Try to add Customer table: you get the error!

Thank you in advance.
Massimiliano Trezzi

nardmoseley

Thanks for providing the steps necessary to encounter the error. After
researching this, I beleive that error exists in prior versions of RB. The
error is not specific to IBExpres - it is an error with the TdaSQL class
which is used by all plug-ins. There is now a patch available for RB 10.06.
Please email support@digital-metaphors.com and request the patch.


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