ODBC and JDBC Developer’s Guide

48 FileMaker ODBC and JDBC Developer’s Guide
O
ODBC
described 13
repeating fields 41
ODBC client driver
catalog functions 40
installing (Mac OS) 17
installing (Windows) 15
mapping data types 41
maximum number of FileMaker fields 41
repeating fields 23
Unicode support 23
verifying access (Mac OS) 18
verifying access (Windows) 16
operating systems 8
operator precedence in SQL expressions 39
ORDER BY (SQL clause) 32
OUTER JOIN 31
P
plug-in 10
R
Rapid Application Development (RAD) tools 19
registering the JDBC client driver 20
relational operators in SQL expressions 36
Remote Data Access Companion (RDAC) 9
repeating fields 23, 41
S
scientific notation in SQL expressions 35
Secure Socket Layer encryption 22
SELECT (SQL statement) 24
SequeLink Server Host 16
SequeLink Server Port 16
Server Data Source 16
sharing a FileMaker data source 8
space in database name 18, 22
SQL aggregate functions 33
SQL expressions 33
character operators 35
constants 34
date operators 35
exponential or scientific notation 35
field names 34
functions 37
literals 34
logical operators 37
numeric operators 35
operator precedence 39
relational operators 36
SQL statements
ALTER TABLE 29
CREATE INDEX 30
CREATE TABLE 29
DELETE 27
DROP INDEX 30
INSERT 27
SELECT 24
supported by client drivers 23
UPDATE 28
SQL-92 conformance 23
T
testing access
JDBC client driver 22
ODBC client driver (Mac OS) 18
ODBC client driver (Windows) 16
U
Unicode support 23
UNION (SQL operator) 32
UPDATE (SQL statement) 28
URL (Uniform Resource Locator) for the JDBC client
driver 20
V
verifying access
JDBC client driver 22
ODBC client driver (Mac OS) 18
ODBC client driver (Windows) 16
W
WHERE (SQL clause) 31
X
xDBC plug-in 10