ODBC and JDBC Guide

5
ALTER TABLE statement 44
CREATE INDEX statement 45
DROP INDEX statement 45
SQL aggregate functions 45
SQL expressions 46
Field names 46
Constants 47
Exponential/scientific notation 48
Numeric operators 48
Character operators 48
Date operators 48
Relational operators 49
Logical operators 50
Functions 51
Functions that return character strings 51
Functions that return numbers 52
Functions that return dates 53
Operator precedence 54
ODBC Catalog functions 54
JDBC Meta Data functions 54
Reserved SQL keywords 55
Chapter 8
Reference Information 58
Mapping FileMaker fields to ODBC data types 58
Mapping FileMaker fields to JDBC data types 58
Data types in 64-bit applications 59
ODBC and JDBC error messages 59
ODBC error messages 59
JDBC error messages 59
Index 61