56 FileMaker ODBC and JDBC Guide
drivers
installing FileMaker JDBC
13
installing FileMaker ODBC 12
uninstalling old 9
DROP INDEX (SQL statement) 36
DSNs
creating (Mac OS)
19
creating (Windows) 17
keyword values for (Mac OS) 19
one per file 9
E
error message formats 51
escape character 19, 24
EXISTS operator 39
exponential notation in SQL expressions 38
expressions in SQL 37
extended privileges 16
F
field names in SQL expressions 37
fields
mapping to JDBC
49
mapping to ODBC 47
FileMaker client drivers. See drivers
FileMaker products
8
filename limitations (Mac OS) 19
files
organizing on one computer
8
setting up access to 16
use in container fields 32
FOR UPDATE (SQL clause) 31
FROM (SQL clause) 29
functions in SQL expressions 41
G
Get(LastError) function 51
Get(LastODBCError) function 51
GetAs function 32, 47
GROUP BY (SQL clause) 29
H
HAVING (SQL clause) 30
holdable cursor 22
hosting a FileMaker data source 7
I
image files in container fields 32
INNER JOIN 29
INSERT (SQL statement) 33
installation requirements 11
installing
FileMaker JDBC client drivers
13
FileMaker ODBC client drivers 12
INT function 42
J
JAR archive files 13
Java Development Kit (JDK) 22
Java version 12
JDBC
client driver, described
22
described 21
error messages 52
overview of using 7
JDBC client driver
driver class and main entry point
22
installing 13
mapping data types 49
meta data functions 44
registering with the JDBC driver manager 23
repeating fields 27
specifying the JDBC URL 22
Unicode support 27
verifying access 25
JDBC SPI 22
JDBCTest 13
join 29
K
keywords
for DSNs (Mac OS)
19
reserved SQL 44
L
LEFT function 41
LEN function 42
LIKE operator 39
literals in SQL expressions 37
Local Data Access Companion (LDAC) 9
logical operators in SQL expressions 40
LOWER function 41
LTRIM function 41
