|
Index 57
M
Mac OS
creating a DSN
19
installing JDBC client driver 13
installing ODBC client driver 13
JDBC client driver requirements 12
ODBC Administrator 19
ODBC client driver requirements 11
mapping data types
JDBC client driver
49
ODBC client driver 47
MAX function 42
meta data functions for JDBC 44
Microsoft Access
client application
8
importing fields into 16
Microsoft Query Wizard 8
MIN function 42
MOD function 42
MONTH function 42
N
network requirements 8
NOT NULL (SQL clause) 35
NOT operator 40
null value 33, 47
numeric operators in SQL expressions 38
NUMVAL function 42
O
ODBC
described
15
error messages 51
overview of using 7
repeating fields 47
standards compliance 27
ODBC Administrator (Mac OS) 19
ODBC client driver
catalog functions
43
installing (Mac OS) 13
installing (Windows) 12
mapping data types 47
maximum number of FileMaker fields 47
repeating fields 27
Unicode support 27
verifying access (Windows) 18
ODBC Data Source Administrator (Windows) 17
operator precedence in SQL expressions 43
OR operator 40
ORDER BY (SQL clause) 30
OUTER JOIN 29
overview
setting up privileges and sharing
16
using ODBC and JDBC with FileMaker 7
P
password
with JDBC
24
with ODBC 18
port
specifying for JDBC
24
specifying for ODBC (Mac OS) 19
specifying for ODBC (Windows) 17
portals 27
positioned updates and deletes 31
POW function 42
privileges, extended 16
Q
QuickTime files in container fields 32
R
Rapid Application Development (RAD) tools 21
REF data type 22
registering the JDBC client driver 23
relational operators in SQL expressions 39
remote access 8
Remote Data Access Companion (RDAC) 9
repeating fields 27, 47
requirements for installation 11
reserved SQL keywords 44
RIGHT function 41
ROUND function 42
RTRIM function 41
S
savepoint support 22
scientific notation in SQL expressions 38
Secure Socket Layer encryption 25
SELECT (SQL statement) 27
SequeLink Server Host 17
SequeLink Server Port 17
Server Data Source 17
sharing, setting up ODBC/JDBC 16
sound files in container fields 32
