, ,

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

9.2 and SQL tables - Attached tables (OpenInsight 32-Bit)

At 26 AUG 2010 03:09:56PM [email protected] wrote:

9.2, Mysql 5.x Connection works.

Bring table CITY up in TableBuilder and all looks well.

F5 - Listtables displays CITY in the list of tables.

F5 - LIST CITY ID NAME COUNTRYCODE returns error 'The "CITY" table is not currently attached. Check your Report Definition.

Either the table is attached … as shown by ListTables OR the table is not attached as shown by the error messsage.

Which one is it?

At 26 AUG 2010 03:12PM DSig (SigSolutions) wrote:

I forgot to mention that under DBManager it shows my SQL tables as attached

At 27 AUG 2010 08:19PM DSig (SigSolutions) wrote:

Even though everything showed the tables attached no tool could access the data until i went through the dataset wizard again

View this thread on the Works forum...