SQL Reference
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Supported standards
- Support for Unicode characters
- SQL statements
- SELECT statement
- SQL clauses
- FROM clause
- WHERE clause
- GROUP BY clause
- HAVING clause
- UNION operator
- ORDER BY clause
- OFFSET and FETCH FIRST clauses
- FOR UPDATE clause
- DELETE statement
- INSERT statement
- UPDATE statement
- CREATE TABLE statement
- TRUNCATE TABLE statement
- ALTER TABLE statement
- CREATE INDEX statement
- DROP INDEX statement
- SQL expressions
- SQL functions
- FileMaker system objects
- Reserved SQL keywords
- Index
Chapter 2
Supported standards
Use the FileMaker ODBC and JDBC client drivers to access a FileMaker Pro database solution
from an ODBC- or JDBC-compliant application. The FileMaker Pro database solution can be
hosted by either FileMaker
Pro or FileMaker Server.
1 The ODBC client driver supports ODBC 3.0 Level 1.
1 The JDBC client driver provides partial support for the JDBC 3.0 specification.
1 The ODBC and JDBC client drivers both support SQL-92 entry-level conformance, with some
SQL-92 intermediate features.
Support for Unicode characters
The ODBC and JDBC client drivers support the Unicode API. However, if you’re creating a custom
application that uses the client drivers, use ASCII for field names, table names, and filenames (in
case a non-Unicode query tool or application is used).
Note To insert and retrieve Unicode data, use SQL_C_WCHAR.
SQL statements
The ODBC and JDBC client drivers provide support for the following SQL statements:
1 SELECT (page 8)
1 DELETE (page 17)
1 INSERT (page 17)
1 UPDATE (page 19)
1 CREATE TABLE (page 20)
1 TRUNCATE TABLE (page 21)
1 ALTER TABLE (page 22)
1 CREATE INDEX (page 22)
1 DROP INDEX (page 23)
The client drivers also support FileMaker data type mapping to ODBC SQL and JDBC SQL data
types. See
FileMaker ODBC and JDBC Guide for data type conversions. For more information on
constructing SQL queries, refer to a third-party book.
Note The ODBC and JDBC client drivers do not support FileMaker Pro portals.