ODBC and JDBC Developer’s Guide
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Using ODBC to share FileMaker data
- Chapter 3 Using JDBC to share FileMaker data
- Chapter 4 Supported standards
- Appendix A Mapping FileMaker fields to ODBC data types
- Appendix B Mapping FileMaker fields to JDBC data types
- Appendix C ODBC and JDBC error messages
- Index
40 FileMaker ODBC and JDBC Developer’s Guide
The following example shows the importance of precedence:
WHERE salary > 40000 OR hire_date > {01/30/2004} AND dept = 'D101'
Because AND is evaluated first, this query retrieves employees in department D101 hired after January 30,
2004, as well as every employee making more than $40,000, no matter what department or hire date.
To force the clause to be evaluated in a different order, use parentheses to enclose the conditions to be
evaluated first. For example:
WHERE (salary > 40000 OR hire_date > {01/30/1989}) AND dept = 'D101'
retrieves employees in department D101 that either make more than $40,000 or were hired after January 30,
2004.
ODBC Catalog functions
The ODBC client driver supports the following Catalog functions:
1 SQLTables - catalog information is stored and reported as single part names (table name only).
1 SQLColumns
1 SQLColumnPrivileges
1 SQLDescribeCol
1 SQLGetTypeInfo
JDBC Meta Data functions
The JDBC client driver supports the following Meta Data functions:
1 getColumns
1 getColumnPrivileges
1 getMetaData
1 getTypeInfo
1 getTables
1 getTableTypes
For JDBC, query Meta Data with the dmd.getFunction command in Java.