Geek asks and answers

FileMaker - ODBC / JBDC connection - which dialect of SQL

I configured DB Visualizer as a JDBC client for FileMaker Pro 10 Server, and it works, but I'm not sure which SQL syntax to use.

For example, it select * from Holidays limit 10gave a parsing error.

Does anyone know the specific syntax? Or at least a few important differences from MySQL?

+3
source share
2 answers

LIMIT is not supported. The Filemaker 10 JDBC documentation does not mention LIMIT in SELECT statement syntax, as in MySQL documentation

+4
source

The limit statement is not supported (and not needed, the JDBC specification is archived so that you simply read the number of lines you want).

: http://www.filemaker.com/downloads/documentation/fm8_odbc_jdbc_developer.pdf

+4

More articles:


All Articles