A SERVICE OF

logo

Open as PDF
next previous
4 FileMaker ODBC and JDBC Guide
Chapter 4
Using JDBC to share FileMaker data 21
About JDBC 21
Using the JDBC client driver 21
About the JDBC client driver 22
Using a JDBC URL to connect to your database 22
Specifying driver properties in the URL subname 24
Verifying access via JDBC 25
Chapter 5
Supported standards 27
Support for Unicode characters 27
SQL statements 27
SELECT statement 27
SQL clauses 28
FROM clause 29
WHERE clause 29
GROUP BY clause 29
HAVING clause 30
UNION operator 30
ORDER BY clause 30
FOR UPDATE clause 31
DELETE statement 33
INSERT statement 33
UPDATE statement 34
CREATE TABLE statement 35
ALTER TABLE statement 35
CREATE INDEX statement 36
DROP INDEX statement 36
SQL aggregate functions 36
SQL expressions 37
Field names 37
Constants and literals 37
Exponential/scientific notation 38
Numeric operators 38
Character operators 38
Date operators 39
Relational operators 39
Logical operators 40
Functions 41
Operator precedence 43
ODBC Catalog functions 43
JDBC Meta Data functions 44
Reserved SQL keywords 44