2 Replies Latest reply on Oct 7, 2010 9:40 AM by philippefurlan

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

    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