ODBC and JDBC Developer’s Guide
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Using ODBC to share FileMaker data
- Chapter 3 Using JDBC to share FileMaker data
- Chapter 4 Supported standards
- Appendix A Mapping FileMaker fields to ODBC data types
- Appendix B Mapping FileMaker fields to JDBC data types
- Appendix C ODBC and JDBC error messages
- Index
Index
A
aggregate functions in SQL 33
ALTER TABLE (SQL statement) 29
B
blank space in database name 18, 22
C
CAST function 26, 41
catalog functions for ODBC 40
character operators in SQL expressions 35
client application, using FileMaker 9
client drivers included 9
configuring a FileMaker data source
via JDBC 21
via ODBC (Mac OS) 18
via ODBC (Windows) 15
constants in SQL expressions 34
container field 26
CREATE INDEX (SQL statement) 30
CREATE TABLE (SQL statement) 29
D
data source
configuring for access via JDBC 21
configuring for access via ODBC (Mac OS) 18
configuring for access via ODBC (Windows) 15
disabling a shared FileMaker database file 8
one DSN for each FileMaker database file 9
using a FileMaker database file 8
verifying access via JDBC 22
verifying access via ODBC (Mac OS) 18
verifying access via ODBC (Windows) 16
Data Source Name 16
data type mapping
JDBC client driver 43
ODBC client driver 41
date operators in SQL expressions 35
DELETE (SQL statement) 27
disabling a shared FileMaker database file 8
driver properties
JDBC client driver 21
ODBC client driver (Mac OS) 18
ODBC client driver (Windows) 15
DROP INDEX (SQL statement) 30
E
escape character 18, 22
exponential notation in SQL expressions 35
expressions in SQL 33
F
field names in SQL expressions 34
FOR UPDATE (SQL clause) 32
FROM (SQL clause) 30
functions in SQL expressions 37
G
GetAs function 26, 41
GROUP BY (SQL clause) 31
H
HAVING (SQL clause) 31
hosting a FileMaker data source 8
I
INNER JOIN 31
INSERT (SQL statement) 27
installing the xDBC plug-in 10
J
Java Development Kit (JDK) 20
JDBC client driver
driver class and main entry point 20
installing 19
mapping data types 43
meta data functions 40
registering with the JDBC driver manager 20
repeating fields 23
specifying the JDBC URL 20
Unicode support 23
verifying access 22
JDBC, described 19
join 31
L
literals in SQL expressions 34
Local Data Access Companion (LDAC) 9
logical operators in SQL expressions 37
M
mapping data types
JDBC client driver 43
ODBC client driver 41
meta data functions for JDBC 40
Microsoft Access client application 8
Microsoft Query Wizard 8
Microsoft SQL Server 9
N
network requirements 8
numeric operators in SQL expressions 35