AnsweredAssumed Answered

Using ODBC to share FileMaker data (mac FM PRO 11) - error

Question asked by philippefurlan on Oct 6, 2010
Latest reply on Oct 7, 2010 by philippefurlan

Title

Using ODBC to share FileMaker data (mac FM PRO 11) - error

Post

on my mac, I setup the ODBC driver that come with FM PRO 11, in order to access FM PRO data.

Everything seams to work except for the following SQL query: 

select * from testDB where ("t"="b")

I got the following error message:

[FileMaker][FileMaker] FQL0007/(1:32): The column named "b" does not exist in any table in the column reference's scope. [HY000]

If I use a query like: select * from testDB , it works as expected.

I am currently using FM PRO 11 Trial, is there some difference with non trial and/or FM PRO Advanced?

Thanks,

Philippe

Outcomes