FileMaker - ODBC/JBDC Connection - What Dialect of SQL

Question

I set up DB Visualizer as a JDBC client for FileMaker Pro 10 Server and it's working but I'm not sure what SQL syntax to use.

For example select * from Holidays limit 10 yielded a parse error.

Does anyone know the specific syntax? Or at least a few of the important differences from say MySQL's SQL?

score 4 · Answer 1 · answered Mar 18 '11 at 14:56

4

The limit statement is not supported (and is not needed, the JDBC spec is architected so that you just read the number of rows you want).

The documentation is here: http://www.filemaker.com/downloads/documentation/fm8_odbc_jdbc_developer.pdf

answered Mar 18 '11 at 14:56

Jesse Barnum

6,507
6
40
69

1

The `LIMIT` or `TOP` clause is still useful in sub-queries. Its a shame FileMaker ODBC does not support them, nor is it optimized for sub-queries :). – CrazyTim Apr 26 '13 at 02:20

score 4 · Accepted Answer · answered Mar 18 '11 at 14:58

4

LIMIT isn't supported. In the Filemaker 10 JDBC documentation there's no mention of LIMIT in the SELECT statement syntax as there is in the MySQL documentation

answered Mar 18 '11 at 14:58

sreimer

4,913
2
33
43

FileMaker - ODBC/JBDC Connection - What Dialect of SQL

2 Answers2