ODBC and JDBC Developer’s Guide

4 FileMaker ODBC and JDBC Developer’s Guide
Chapter 4
Supported standards 23
Support for Unicode characters 23
SQL statements and clauses 23
SELECT statement 24
D ELETE statement 27
INSERT statement 27
UPDATE statement 28
C REATE TABLE statement 29
ALTER TABLE statement 29
CREATE INDEX statement 30
DROP INDEX statement 30
FROM clause 30
W HERE clause 31
GROUP BY clause 31
HAVING clause 31
UNION operator 32
O RDER BY clause 32
FOR UPDATE clause 32
SQL aggregate functions 33
SQL expressions 33
F ield names 34
Constants and literals 34
Exponential/scientific notation 35
Numeric operators 35
Character operators 35
Date operators 35
Relational operators 36
Logical operators 37
Functions 37
Operator precedence 39
ODBC Catalog functions 40
JDBC Meta Data functions 40
Appendix A
Mapping FileMaker fields to ODBC data types 41
Appendix B
Mapping FileMaker fields to JDBC data types 43