1 Reply Latest reply on Dec 28, 2011 7:40 AM by JoeHodsdon

    SQL query via ODBC: referencing table name containing period

    JoeHodsdon

      Title

      SQL query via ODBC: referencing table name containing period

      Post

      I'm using an ODBC connection to send SQL queries to a FM11 database. When I try to reference a table that has a period in its name, FileMaker seems to ignore the part before the period. For example, the following query

      SELECT * FROM Loc.Assignment

      will return the error

      [FileMaker][FileMaker] FQL0002/(1:18): The table named "Assignment" does not exist.

      Is there a way to escape the period or delimit the table name? Am I misuderstanding the semantics of a period in a FM table name? It's not my database, so I can't simply rename the table that contain periods. Thanks!

        • 1. Re: SQL query via ODBC: referencing table name containing period
          JoeHodsdon

          It turns out that I was misunderstanding the table name semantics for ODBC queries. The table name I was referencing in my query appears in the list on the Tables tab of FileMaker's Manage Database dialog. Apparently, table names used in ODBC queries must reference a name used in the graph on the Relationships tab instead. My query worked as expected when I changed "Loc.Assignments" to one of the names in the Relationships graph that refers to it.