ODBC and JDBC Guide

63
N
network requirements 9
NOT IN operator 49
NOT LIKE operator 49
NOT NULL (SQL clause) 43
NOT operator 50
null value 41
, 58
numeric operators in SQL expressions 48
NUMVAL function 53
O
ODBC
described 20
error messages 59
overview of using 6
repeating fields 58
standards compliance 34
ODBC Administrator (Mac OS) 26
ODBC client driver
catalog functions 54
mapping data types 58
portals 34
Unicode support 34
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) 38
OUTER JOIN 36
overview
setting up privileges and sharing 21
using ODBC and JDBC with FileMaker 6
P
password
with JDBC 31
with ODBC 24
, 26
PI function 53
port, specifying for JDBC 28
portals 34
positioned updates and deletes 38
PREVENT INDEX CREATION 45
privileges, extended 21
Q
QuickTime files in container fields 40
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 8
repeating fields 58
requirements for installation 13
, 27
reserved SQL keywords 55
RIGHT function 51
RIGHT JOIN 36
RIGHT OUTER JOIN 36
ROUND function 53
RTRIM function 51
S
savepoint support 29
scientific notation in SQL expressions 48
SECOND function 53
SELECT (SQL statement) 34
binary data 39
BLOB data type 39
empty string 39
Server Data Source 25
sharing, setting up ODBC/JDBC 21
SIGN function 53
SIN function 53
SPACE function 51
SQL aggregate functions 45
SQL expressions 46
character operators 48
constants 47
date operators 48
exponential or scientific notation 48
field names 46
functions 51
logical operators 50
numeric operators 48
operator precedence 54
relational operators 49
SQL standards compliance 34
SQL statements
ALTER TABLE 44
CREATE INDEX 45
CREATE TABLE 43
DELETE 41
DROP INDEX 45
INSERT 41
reserved keywords 55
SELECT 34
supported by client drivers 34
UPDATE 42
SQL_C_WCHAR data type 34
SQL-92 34
SQLExceptions 59
SQRT function 53
standards compliance 34
string functions 51
STRVAL function 51
subqueries 41
SUBSTR function 51
SUBSTRING function 51
syntax errors 55
system requirements 13
, 27