Index
A
Access via ODBC/JDBC extended privilege 16
Access, Microsoft. See Microsoft Access
accounts and privileges
16
aggregate functions in SQL 36
aliases with SELECT statement 28, 31
ALL operator 39
ALTER TABLE (SQL statement) 35
AND operator 40
ANY operator 39
APIs 7
ARRAY data type 22
auto-generated keys 22
B
B function 42
BETWEEN operator 39
bitmap files in container fields 32
blank characters 38
blank space in database name 19, 24
blank value in columns 33
BLOB data type
JDBC limitation
22
use in CREATE TABLE 35
use in SELECT 31
Boolean data type 22
C
CAST function 32, 47
catalog functions for ODBC 43
character operators in SQL expressions 38
CHR function 41
client application, using FileMaker as 7
client drivers. See drivers
CLOB data type
22
column aliases 28
column names 16
configuring a FileMaker data source
via JDBC
24
via ODBC (Mac OS) 19
via ODBC (Windows) 17
connections, database 8
constants in SQL expressions 37
container field
JDBC data type mapping
49
ODBC data type mapping 47
with INSERT statement 33
with SELECT statement 32
with UPDATE statement 34
CREATE INDEX (SQL statement) 36
CREATE TABLE (SQL statement) 35
cursors
in JDBC
22
in ODBC 31
D
data source
configuring for access via JDBC
24
configuring for access via ODBC (Mac OS) 19
configuring for access via ODBC (Windows) 17
disabling a shared FileMaker database file 8
one DSN for each FileMaker database file 9
using FileMaker as 7
verifying access via JDBC 25
verifying access via ODBC (Windows) 18
data source names. See DSNs
data type mapping
JDBC client driver 49
ODBC client driver 47
database connections, number supported 8
database name considerations
Mac OS
19
Windows 18
DATALINK data type 22
DATE function 42
date operators in SQL expressions 39
DATEVAL function 42
DAY function 42
DAYOFWEEK function 42
DELETE (SQL statement) 33
disabling a shared FileMaker database file 8
DISTINCT operator 28
driver properties
JDBC client driver
24
ODBC client driver (Mac OS) 19
ODBC client driver (Windows) 17
