A SERVICE OF

logo

58 FileMaker ODBC and JDBC Guide
SPACE function 41
space in database name 19, 24
SQL aggregate functions 36
SQL expressions 37
character operators 38
constants 37
date operators 39
exponential or scientific notation 38
field names 37
functions 41
literals 37
logical operators 40
numeric operators 38
operator precedence 43
relational operators 39
SQL standards compliance 27
SQL statements
ALTER TABLE
35
CREATE INDEX 36
CREATE TABLE 35
DELETE 33
DROP INDEX 36
INSERT 33
reserved keywords 44
SELECT 27
supported by client drivers 27
UPDATE 34
SQL_C_BINARY data type 27
SQL_C_WCHAR data type 27
SQL-92 27
SQLExceptions 52
standards compliance 27
string functions 41
STRVAL function 41
subqueries 33
SUBSTR function 41
syntax errors 44
system requirements 11
T
table aliases 28, 29
testing access
JDBC client driver
25
ODBC client driver (Windows) 18
TIME function 41
TRIM function 41
U
Unicode support 27
UNION (SQL operator) 30
UPDATE (SQL statement) 34
UPPER function 41
URL (Uniform Resource Locator) for the JDBC
client driver
22
USERNAME function 41
V
VAL function 42
VALUES (SQL clause) 33
verifying access
JDBC client driver
25
ODBC client driver (Windows) 18
W
WHERE (SQL clause) 29
wildcards with SELECT statement 28, 31
Windows
creating a DSN
17
importing fields into Microsoft Access 16
installing JDBC client driver 13
installing ODBC client driver 12
JDBC client driver requirements 12
ODBC client driver requirements 11
verifying ODBC access 18
X
X function 42
Y
YEAR function 42