ユーザーズマニュアル目次Chapter 1 Introduction7About this guide7Using a FileMaker database as a data source7Accessing a hosted FileMaker Pro database8Limitations with third-party tools8Networking requirements8Updating files from previous versions9Installing current drivers9Chapter 2 Installing FileMaker ODBC and JDBC client drivers11Abiding by the license agreement11Hardware and software requirements11ODBC client driver requirements (Windows)11ODBC client driver requirements (Mac OS)11JDBC client driver requirements12Networking requirements12ODBC client driver installation (Windows)12ODBC client driver installation (Mac OS)13JDBC client driver installation (Windows and Mac OS)13Configuring client drivers14Where to go from here14Chapter 3 Using ODBC to share FileMaker data15About ODBC15Using the ODBC client driver16Overview of accessing a FileMaker database file16Accessing a FileMaker database file from a Windows application17Specifying ODBC client driver properties for a FileMaker DSN (Windows)17Verifying access via ODBC (Windows)18Accessing a FileMaker database file from a Mac OS application19Configuring the ODBC client driver (Mac OS)19Specifying ODBC client driver properties for a FileMaker DSN (Mac OS)19Chapter 4 Using JDBC to share FileMaker data21About JDBC21Using the JDBC client driver21About the JDBC client driver22Using a JDBC URL to connect to your database22Specifying driver properties in the URL subname24Verifying access via JDBC25Chapter 5 Supported standards27Support for Unicode characters27SQL statements27SELECT statement27SQL clauses28FROM clause29WHERE clause29GROUP BY clause29HAVING clause30UNION operator30ORDER BY clause30FOR UPDATE clause31DELETE statement33INSERT statement33UPDATE statement34CREATE TABLE statement35ALTER TABLE statement35CREATE INDEX statement36DROP INDEX statement36SQL aggregate functions36SQL expressions37Field names37Constants and literals37Exponential/scientific notation38Numeric operators38Character operators38Date operators39Relational operators39Logical operators40Functions41Operator precedence43ODBC Catalog functions43JDBC Meta Data functions44Reserved SQL keywords44Appendix A Mapping FileMaker fields to ODBC data types47Appendix B Mapping FileMaker fields to JDBC data types49Appendix C ODBC and JDBC error messages51ODBC error messages51ODBC driver error messages51ODBC Driver Manager error messages51SequeLink Client error messages51SequeLink Server error messages52Data source error messages52JDBC error messages52JDBC driver error messages52SequeLink Server error messages52Data source error messages53Index55サイズ: 1.2MBページ数: 58Language: Englishマニュアルを開く