Return to FileMaker.com
Query Syntax Error com.filemaker.jdbc.FMSQLException FQL0001/(1:56)
I am running into this error:
Error: com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] FQL0001/(1:56): There is an error in the syntax of the query.
This is the SQL that I'm running:
SELECT * FROM Table
I don't get the error on some services like SQuirreLSQL, which makes me think it's something on FileMaker Pro Advanced 11.0v4's side.
If you actually use 'Table' as the table name, you need to escape it with double quotes as it's a SQL reserved word.
SELECT * FROM "Table"
Retrieving data ...