AnsweredAssumed Answered

SQL query via ODBC: referencing table name containing period

Question asked by JoeHodsdon on Dec 21, 2011
Latest reply on Dec 28, 2011 by 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!

Outcomes