ODBC and JDBC Developer’s Guide

4 FileMaker ODBC and JDBC Developer’s Guide
Chapter 4
Supported standards 25
Support for Unicode characters 25
SQL statements and clauses 25
SELECT statement 25
DELETE statement 28
INSERT statement 29
UPDATE statement 30
CREATE TABLE statement 30
ALTER TABLE statement 31
CREATE INDEX statement 31
DROP INDEX statement 32
FROM clause 32
WHERE clause 33
GROUP BY clause 33
HAVING clause 33
UNION operator 33
ORDER BY clause 34
FOR UPDATE clause 34
SQL aggregate functions 35
SQL expressions 35
Field names 36
Constants and literals 36
Exponential/scientific notation 37
Numeric operators 37
Character operators 37
Date operators 37
Relational operators 38
Logical operators 39
Functions 39
Operator precedence 41
ODBC Catalog functions 42
JDBC Meta Data functions 42
Appendix A
Mapping FileMaker fields to ODBC data types 43
Appendix B
Mapping FileMaker fields to JDBC data types 45