ODBC and JDBC Guide

56 FileMaker ODBC and JDBC Guide
DSNs
creating (Mac OS)
19
creating (Windows) 17
keyword values for (Mac OS) 20
one per file 9
E
error message formats 51
escape character 20, 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) 30
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
21
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 43
registering with the JDBC driver manager 22
repeating fields 27
specifying the JDBC URL 22
Unicode support 27
verifying access 25
JDBC SPI 22
JDBCTest 14
join 29
K
keywords
for DSNs (Mac OS)
20
reserved SQL 44
L
LEFT function 41
LEN function 42
LIKE operator 39
literals in SQL expressions 37
logical operators in SQL expressions 40
LOWER function 41
LTRIM function 41
M
Mac OS
creating a DSN
19
installing JDBC client driver 13
installing ODBC client driver 13
JDBC client driver requirements 12
ODBC Administrator 13, 19