Return to FileMaker.com
odbc error syntax
Hello! I'm use FileMaker 12 PRO Ad for access to filemaker base throughout ODBC.When i use querySelect * from Invoices WHERE Date>'2013-03-15'I get error message (Microsoft OLE DB Provider for ODBC Drivers): [FileMaker][FileMaker] FQL0001/(1:30): There is an error in the syntax of the query.How use "Date" in query?Thanks!
Pull down Help. Select ODBC and JDBC Guide from the Product Documentation Sub menu. There are a number of examples of SQL queries, including some that work with dates in that PDF document.
Retrieving data ...