Using ODBC to share FileMaker data (mac FM PRO 11) - error
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?