ODBC and JDBC Developer’s Guide

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