Filemaker Switch ODBC User Manual

FileMaker® 9ODBC and JDBC Guide

10 FileMaker ODBC and JDBC Guide

Chapter 2Installing FileMaker ODBC and JDBC client driversThese instructions help you install the drivers needed to access a FileMaker data source fro

12 FileMaker ODBC and JDBC GuideJDBC client driver requirementsTo find which version of Java you’re running, open a command window (Windows) or Te

Chapter 2 | Installing FileMaker ODBC and JDBC client drivers 13ODBC client driver installation (Mac OS)If you have previously installed the ODB

14 FileMaker ODBC and JDBC Guide6. Click Next.7. Confirm your installation selections, then click Install.8. When the installation is complete,

Chapter 3Using ODBC to share FileMaker dataUse the ODBC client driver to connect to a FileMaker data source from another application. The application

16 FileMaker ODBC and JDBC GuideUsing the ODBC client driverYou can use the ODBC client driver with any ODBC-compliant application. Sharing your F

Chapter 3 | Using ODBC to share FileMaker data 17Accessing a FileMaker database file from a Windows applicationSpecifying ODBC client driver pro

18 FileMaker ODBC and JDBC Guide10. If you’ve enabled sharing via ODBC/JDBC in the host application, click the button to the right of Server Data

Chapter 3 | Using ODBC to share FileMaker data 19Accessing a FileMaker database file from a Mac OS applicationIf you build custom applications,

© 2004-2007 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054FileMaker is a trademark of Fi

20 FileMaker ODBC and JDBC Guide

Chapter 4Using JDBC to share FileMaker dataIf you’re a Java programmer, you can use the JDBC client driver with any Rapid Application Development (RAD

22 FileMaker ODBC and JDBC GuideAbout the JDBC client driverThe JDBC client driver provides partial support for the JDBC 3.0 specification. The fo

Chapter 4 | Using JDBC to share FileMaker data 23Registering the JDBC client driver and connecting to a FileMaker data source (an example)Here i

24 FileMaker ODBC and JDBC GuideSpecifying driver properties in the URL subnameSpecify the user and password driver properties in the subname of t

Chapter 4 | Using JDBC to share FileMaker data 25JDBC URL connection with the database name, user name, and password specified in the URLFormat

26 FileMaker ODBC and JDBC Guide

Chapter 5Supported standardsThis chapter describes the SQL statements and constructs supported by the FileMaker ODBC and JDBC client drivers. Use the

28 FileMaker ODBC and JDBC GuideThe SELECT statement can use a variety of clauses:SELECT [DISTINCT] {* | column_expression [[AS] column_alias],...

Chapter 5 | Supported standards 29FROM clauseThe FROM clause indicates the tables that are used in the SELECT statement. The format is:FROM tabl

ContentsChapter 1 Introduction 7About this guide 7Using a FileMaker database as a data source 7Accessing a hosted FileMaker Pro database 8L

30 FileMaker ODBC and JDBC GuideHAVING clauseThe HAVING clause enables you to specify conditions for groups of records (for example, display only

Chapter 5 | Supported standards 31FOR UPDATE clauseThe FOR UPDATE clause performs Positioned Updates or Positioned Deletes via SQL cursors. The

32 FileMaker ODBC and JDBC GuideRetrieving the contents of a container field: CAST() function and GetAs() functionYou can retrieve binary data, fi

Chapter 5 | Supported standards 33DELETE statementUse the DELETE statement to delete records from a database table. The format of the DELETE sta

34 FileMaker ODBC and JDBC GuideThe SELECT statement is a query that returns values for each column_name value specified in the column name list.

Chapter 5 | Supported standards 35CREATE TABLE statementUse the CREATE TABLE statement to create a table in a database file. The format of the C

36 FileMaker ODBC and JDBC GuideCREATE INDEX statementUse the CREATE INDEX statement to speed searches in your database file. The format of the CR

Chapter 5 | Supported standards 37ExamplesSELECT SUM (Sales_Data.Amount) AS agg FROM Sales_DataSELECT AVG (Sales_Data.Amount) AS agg FROM Sales_

38 FileMaker ODBC and JDBC GuideYou must enclose date, time, and timestamp constants in braces ({}), for example, {D '2005-06-05'}, {14:

Chapter 5 | Supported standards 39Date operatorsYou can modify dates.ExamplesIn the following examples, hire_date is {01/30/2004}.Additional exa

4 FileMaker ODBC and JDBC GuideChapter 4 Using JDBC to share FileMaker data 21About JDBC 21Using the JDBC client driver 21About the JDBC c

40 FileMaker ODBC and JDBC GuideSELECT Sales_Data.Time_Sold FROM Sales_Data WHERE Sales_Data.Time_Sold < '12:00:00'SELECT Sales_Data.

Chapter 5 | Supported standards 41FunctionsThe ODBC and JDBC client drivers support many functions you can use in expressions. Some of the funct

42 FileMaker ODBC and JDBC GuideSELECT SPACE(2) + Salespeople.Salesperson_ID AS Salesperson_ID FROM SalespeopleSELECT STRVAL('60506') AS

Chapter 5 | Supported standards 43Operator precedenceAs expressions become more complex, the order in which the expressions are evaluated become

44 FileMaker ODBC and JDBC GuideJDBC Meta Data functionsThe JDBC client driver supports the following Meta Data functions:1 getColumns1 getColumnP

45 FileMaker ODBC and JDBC GuideReserved keywordsIFIFNULLIGNOREIMMEDIATEININDEXINDICATORINITIALLYINNERINPUTINSENSITIVEINSERTINTINTEGERINTERSECTINT

46 FileMaker ODBC and JDBC Guide

Appendix AMapping FileMaker fields to ODBC data typesThis table illustrates how FileMaker field types map to the standard ODBC data types. String leng

48 FileMaker ODBC and JDBC Guide

Appendix BMapping FileMaker fields to JDBC data typesThe JDBC client driver uses the following mappings when converting FileMaker data types to JDBC S

| Contents 5Appendix A Mapping FileMaker fields to ODBC data types 47Appendix B Mapping FileMaker fields to JDBC data types 49Appendix C OD

50 FileMaker ODBC and JDBC Guide

Appendix CODBC and JDBC error messagesHere are the basic formats of error messages you receive when working with FileMaker and ODBC/JDBC. For a listin

52 FileMaker ODBC and JDBC GuideSequeLink Server error messagesAn error reported by the SequeLink Server has the following format:[DataDirect] [OD

Appendix C | ODBC and JDBC error messages 53Data source error messages An error that occurs in the data source includes the data source name, in

54 FileMaker ODBC and JDBC Guide

IndexAAccess via ODBC/JDBC extended privilege 16Access, Microsoft. See Microsoft Accessaccounts and privileges 16aggregate functions in SQL 36al

56 FileMaker ODBC and JDBC Guidedriversinstalling FileMaker JDBC 13installing FileMaker ODBC 12uninstalling old 9DROP INDEX (SQL statement)

| Index 57MMac OScreating a DSN 19installing JDBC client driver 13installing ODBC client driver 13JDBC client driver requirements 12ODB

58 FileMaker ODBC and JDBC GuideSPACE function 41space in database name 19, 24SQL aggregate functions 36SQL expressions 37character operat

6 FileMaker ODBC and JDBC Guide

Chapter 1IntroductionThis guide explains concepts and details to help you share FileMaker® data with other applications using ODBC (Open Database Conn

8 FileMaker ODBC and JDBC GuideSQL is passed through the ODBC and JDBC interfaces to the FileMaker host of the data source, performing queries suc

Chapter 1 | Introduction 9Updating files from previous versionsIf you used LDAC (Local Data Access Companion) or RDAC (Remote Data Access Compan