ODBC and JDBC Guide

4
Chapter 4
Using ODBC to share FileMaker data 20
About ODBC 20
Using the ODBC client driver 21
Overview of accessing a FileMaker database file 21
Accessing a FileMaker database file from a Windows application 22
Specifying ODBC client driver properties for a FileMaker DSN (Windows) 22
Changing an existing ODBC client driver (Windows) 22
Verifying access via ODBC (Windows) 24
Accessing a FileMaker database file from a Mac OS application 24
Specifying ODBC client driver properties for a FileMaker DSN (Mac OS) 24
Changing an existing ODBC client driver (Mac OS) 24
Verifying access via ODBC (Mac OS) 26
Chapter 5
Installing FileMaker JDBC client drivers 27
Software requirements 27
Networking requirements 27
JDBC client driver installation 27
Using the JDBC client driver 28
Chapter 6
Using JDBC to share FileMaker data 29
About JDBC 29
Using the JDBC client driver 29
About the JDBC client driver 29
Using a JDBC URL to connect to your database 30
Specifying driver properties in the URL subname 31
Solutions with multiple FileMaker database files 32
Verifying access via JDBC 32
Chapter 7
Supported standards 34
Support for Unicode characters 34
SQL statements 34
SELECT statement 34
SQL clauses 35
FROM clause 35
WHERE clause 36
GROUP BY clause 37
HAVING clause 37
UNION operator 37
ORDER BY clause 38
FOR UPDATE clause 38
DELETE statement 41
INSERT statement 41
UPDATE statement 42
CREATE TABLE statement 43