ODBC and JDBC Guide

|
Index 63
LOG function 53
logical operators in SQL expressions 50
LOWER function 51
LTRIM function 51
M
Mac OS
creating a DSN
25
JDBC client driver requirements 27
ODBC client driver requirements 15
verifying ODBC access 26
mapping data types
JDBC client driver
59
ODBC client driver 59
MAX function 53
meta data functions for JDBC 55
MIN function 53
MINUTE function 53
MOD function 53
MONTH function 53
MONTHNAME function 51
N
network requirements 10
NOT IN operator 49
NOT LIKE operator 49
NOT NULL (SQL clause) 44
NOT operator 50
null value 42, 59
numeric operators in SQL expressions 48
NUMVAL function 53
O
ODBC
described
21
error messages 60
overview of using 7
repeating fields 59
standards compliance 35
ODBC Administrator (Mac OS) 26
ODBC client driver
catalog functions
55
mapping data types 59
portals 35
Unicode support 35
verifying access (Mac OS) 26
verifying access (Windows) 24
ODBC Data Source Administrator (Windows) 25
operator precedence in SQL expressions 54
OR operator 50
ORDER BY (SQL clause) 39
OUTER JOIN 37
overview
setting up privileges and sharing
22
using ODBC and JDBC with FileMaker 7
P
password
with JDBC
31
with ODBC 24, 26
PI function 53
port, specifying for JDBC 28
portals 35
positioned updates and deletes 39
POW function 53
PREVENT INDEX CREATION 46
privileges, extended 22
Q
QuickTime files in container fields 41
R
RADIANS function 53
Rapid Application Development (RAD) tools 29
REF data type 30
registering the JDBC client driver 30
relational operators in SQL expressions 49
remote access 9
repeating fields 59
requirements for installation 15, 27
reserved SQL keywords 55
RIGHT function 51
RIGHT JOIN 37
RIGHT OUTER JOIN 37
ROUND function 53
RTRIM function 51
S
savepoint support 29
scientific notation in SQL expressions 48
SECOND function 53
SELECT (SQL statement) 35
binary data 40
BLOB data type 40
empty string 40