FileMaker ODBC and JDBC Guide

Transcription

1 FileMaker 12 ODBC JDBC

2 FileMaker, Inc. All Rights Reserved. FileMaker, Inc Patrick Henry Drive Santa Clara, California FileMaker Bento FileMaker, Inc. Bento FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgements URL 01

3 1 6 6 ODBC JDBC 6 ODBC FileMaker 7 ODBC 7 ODBC 7 FileMaker 8 FileMaker Pro SQL 10 ODBC 10 ODBC SQL 11 ODBC 12 FileMaker ODBC 12 3 FileMaker ODBC ODBC Windows 14 ODBC Mac OS ODBC 15 ODBC Windows 15 Windows 16 ODBC Windows 16 DSN Windows 17 ODBC Mac OS 18 Mac OS 19 20

4 4 4 ODBC FileMaker 21 ODBC 21 ODBC 22 FileMaker 23 Windows FileMaker 23 FileMaker DSN ODBC Windows 23 ODBC Windows 23 ODBC Windows 25 Mac OS FileMaker 26 FileMaker DSN ODBC Mac OS 26 ODBC Mac OS 26 ODBC Mac OS 27 5 FileMaker JDBC JDBC 29 JDBC 30 6 JDBC FileMaker 31 JDBC 31 JDBC 31 JDBC 32 JDBC URL 33 URL 34 FileMaker 35 JDBC Unicode 36 SQL 36 SELECT 37 SQL 37 FROM 37 WHERE 38 GROUP BY 39 HAVING 39 UNION 39

5 5 ORDER BY 40 FOR UPDATE 40 DELETE 43 INSERT 43 UPDATE 44 CREATE TABLE 45 ALTER TABLE 46 CREATE INDEX 46 DROP INDEX 47 SQL 47 SQL ODBC 56 JDBC 56 SQL FileMaker ODBC 60 FileMaker JDBC ODBC JDBC 61 ODBC 61 JDBC 61 63

6 1 FileMaker ODBC ODBC JDBC FileMaker ODBC JDBC 1 ODBC FileMaker ODBC 1 FileMaker Pro 1 FileMaker Pro Advanced FileMaker Pro [ ] > [ ] 1 FileMaker Server 1 SQL [ ] 1 FileMaker Server ODBC [SQL ] Advanced [ExecuteSQL] 1 FileMaker 1 FileMaker Pro ODBC 1. SQL 2. ODBC JDBC 1 FileMaker Pro 1 FileMaker Pro Advanced 1 FileMaker Server Advanced FileMaker Pro ODBC JDBC 1 ODBC JDBC SQL 1 FileMaker Pro Advanced FileMaker ProFileMaker Pro FileMaker Pro Advanced FileMaker Web ODBC JDBC ODBC JDBC APIODBC C API JDBC Java API API FileMaker Pro FileMaker Server Advanced ODBC JDBC SQL SQL

7 1 7 ODBC JDBC API FileMaker ODBC FileMaker ODBC FileMaker SQL FileMaker ODBC SQL ODBC ODBC ODBC ODBC 1 [ ] ODBC FileMaker Pro SQL SQL 1 [ ] [SQL ] [ExecuteSQL] FileMaker SQL SQL ODBC SQL ODBC ODBC ODBC ODBC FileMaker SQL 1 ODBC 1 ODBC ODBC 1 1 FileMaker ODBC FileMaker Pro ODBC SQL FileMaker Pro OracleSQL Server MySQL FileMaker Pro ODBC 2 SQL FileMaker ODBC

8 1 8 FileMaker FileMaker ODBC JDBC FileMaker FileMaker ODBC JDBC SQL FileMaker FileMaker Pro FileMaker Server Advanced FileMaker Pro FileMaker ODBC JDBC FileMaker FileMaker FileMaker Server Advanced FileMaker Pro 50 Web FileMaker FileMaker ODBC JDBC FileMaker Server Advanced FileMaker Pro FileMaker ODBC ODBC ODBC JDBC FileMaker Pro FileMaker Server Advanced ODBCOpen Database ConnectivityJDBCJava Database Connectivity SQL 1 ODBC FileMaker 3 FileMaker ODBC 1 FileMaker FileMaker ODBC 4 ODBC FileMaker 1 JDBC FileMaker 5 FileMaker JDBC 1 FileMaker JDBC FileMaker Java 6 JDBC FileMaker 1 ODBC JDBC FileMaker Pro FileMaker Server Advanced SQL 7 ODBC/JDBC FileMaker Server Advanced FileMaker Pro ODBC JDBC FileMaker FileMaker

9 1 9 Microsoft AccessMicrosoft Access FileMaker Microsoft Access Microsoft Access FileMaker Server Advanced FileMaker TCP/IP FileMaker Pro FileMaker Pro FileMaker Server Advanced 12 FileMaker 12 FileMaker Pro FileMaker Server Advanced 3 FileMaker ODBC 5 FileMaker JDBC FileMaker DSN DSN FileMaker DSN

10 2 SQL ODBC FileMaker SQL FileMaker ODBC SQL ODBC ODBC ODBC ODBC ODBC Oracle Oracle ODBC ODBC SQL ODBC FileMaker Pro SQL ODBC FileMaker Pro ODBC Oracle Microsoft Access FileMaker Pro FileMaker Pro [ ] [ ] [SQL ] [ExecuteSQL] ODBC ODBC 1 ODBC 1 FileMaker Pro ODBC DSN 1 ODBC

11 2 SQL 11 1 FileMaker Pro 1 FileMaker Pro [] > [] > [ODBC...] 1 FileMaker Pro [ ] > [...] [...] [ ]Windows [ ]Mac OS [ODBC...] [OK] FileMaker Pro SQL FileMaker Pro SQL SQL [WHERE] [ORDER BY] SQL Query SQL [ ] [SQL ] [ExecuteSQL] FileMaker ODBC [SQL ] SQL FileMaker Pro Advanced SQL FileMaker FileMaker Pro ODBC SQL ODBC FileMaker Pro [SQL ] [ExecuteSQL] SQL INSERTUPDATE DELETE SQL FileMaker Pro SQL FileMaker Pro SQL Server SQL [SQL ] [ExecuteSQL] FileMaker FileMaker Pro

12 2 SQL 12 ODBC ODBC FileMaker SQL ODBC FileMaker Pro FileMaker Server SQL ODBC FileMaker Pro FileMaker Pro FileMaker Pro FileMaker Server SQL FileMaker Pro FileMaker 12 ODBC FileMaker ODBC SQL 1 Oracle 10g 1 Oracle 11g 1 SQL Server SQL Server MySQL 5.1 Community Edition ODBC ODBC FileMaker Pro 1 ODBC 1 FileMaker Pro ODBC DSN 1 ODBC 1 ODBC FileMaker Pro

13 2 SQL 13 1 FileMaker Pro 1 ODBC ODBC ODBC ODBC ODBC FileMaker Pro

14 3 FileMaker ODBC ODBCOpen Database Connectivity FileMaker ODBC ODBC FileMaker xdbc FileMaker URL FileMaker Server Advanced FileMaker FileMaker SQL ODBC ODBC Windows 1 Pentium III 700MHz 1 Windows XP 256 MB RAM 2 GBWindows VistaWindows 7 Windows Server 2008 R2 1 GB RAM 1 Microsoft Data Access ComponentsMDAC 2.8 SP1Vista Windows MDAC 6.0MDAC Windows Windows ODBC Mac OS 1 Intel Mac OS 1 1 GB RAM 2 GB 1 Mac OS X 10.6FileMaker FileMaker TCP/IP

15 3 FileMaker ODBC 15 ODBC FileMaker Windows Mac OS ODBC FileMaker Pro 32 xdbc Listener FileMaker Server Advanced xdbc Listener64 64 xdbc Listener xdbc Listener ODBC ODBC ODBC ODBC Windows Windows Windows Windows ODBC 1. 1.exe 1 2. FileMaker Pro FileMaker Server xdbc 3. xdbcodbc Client Driver Installer 4. ODBC Client Driver Installer 1 32 fmodbc32.dll32 [FMODBC_Installer_Win32.msi] 1 64 fmodbc64.dll64 [FMODBC_Installer_Win64.msi] FileMaker ODBC Driver Setup Wizard 5. ODBC

16 3 FileMaker ODBC [ ] ODBC 1 32 Windows 32 fmodbc32.dll c:windowssystem Windows 32 fmodbc32.dll c:windowssyswow Windows 64 fmodbc64.dll c:windowssystem32 FileMaker ODBC [FileMaker ODBC] Windows ODBC FileMaker FileMaker 2399 ODBC Windows ODBC ODBC 32 Windows 32 ODBC Windows [ ] > [ (ODBC)] 1 Windows XP [ ] [ ] 1 Windows Vista Windows 7 [ ] [ ] 32 [ODBC ] 64 Windows 32 ODBC 1. SysWoW64SysWoW64 c: windowssyswow64 2. odbcad32.exe 32 [ODBC ]

17 3 FileMaker ODBC Windows 64 ODBC Windows [ ] > [ (ODBC)] 1 Windows XP [ ] [ ] 1 Windows Vista Windows 7 [ ] [ ] 64 [ODBC ] DSN Windows ODBC 1. [ODBC ] [ DSN] [ DSN] 2. [...] [ ] 3. [FileMaker ODBC] [ ] [FileMaker DSN ] 4. [ ] 5. [ ] FileMaker [ ] FileMaker [ ] 6. [ ] 1 FileMaker Pro localhost IP FileMaker Server Advanced FileMaker Server IP ODBC/JDBC [ ] [ ] [ ]

18 3 FileMaker ODBC [ ] FileMaker FileMaker Server Advanced [ ] FileMaker Server [ ] [ ] 1 [ ] 1 [ ] MS Word 255 PHP [ long varchar ] 255 Windows 255 Mac OS [ ] [ ] 8. FileMaker DSN 1 [ ] FileMaker ODBC FileMaker FileMaker ODBC/JDBC FileMaker Pro FileMaker Server Advanced ODBC/JDBC 1 [ ] ODBC Mac OS Mac OS / /ODBC FileMaker ODBC.bundleODBC ODBC 1. 1.dmg 1 2. FileMaker Pro FileMaker Server xdbc 3. xdbcodbc Client Driver Installer 4. ODBC Client Driver Installer [FileMaker ODBC.mpkg] FileMaker ODBC Driver Installer

19 3 FileMaker ODBC ODBC 6. [ ] ODBC / /ODBC ODBC FileMaker ODBC [FileMaker ODBC] Mac OS ODBC FileMaker FileMaker Actual Technologies ODBC Manager Apple ODBC Administrator Tool for Mac OS X Mac OS X 10.6 ODBC Administrator ODBC ODBC FileMaker DSN ODBC FileMaker 2399 ODBC 1. ODBC Manager ODBC Manager 2. [ DSN] [ DSN] [...] [ ] 3. [FileMaker ODBC] [OK] [FileMaker DSN ] 4. [ ] 5. [ ] FileMaker [ ] FileMaker [ ] 6. [ ] 1 FileMaker Pro localhost IP FileMaker Server Advanced FileMaker Server IP ODBC/JDBC [ ] [ ] [ ]

20 3 FileMaker ODBC [ ] FileMaker FileMaker Server Advanced [ ] FileMaker Server [ ] [ ] 1 [ ] 1 [ ] MS Word 255 PHP [ long varchar ] [ ] [ ] 8. FileMaker DSN 1 [ ] FileMaker ODBC FileMaker FileMaker ODBC/JDBC FileMaker Pro FileMaker Server Advanced ODBC/JDBC 1 [ ] SQL FileMaker ODBC [ ] [SQL ] ODBC FileMaker 4 ODBC FileMaker

21 4 ODBC FileMaker ODBC FileMaker ODBC FileMaker FileMaker ODBC FileMaker ODBC FileMaker Pro ODBC SQL ODBC ODBC SQL 2 SQL ODBC ODBC API ODBC ODBC SQL SQL FileMaker ODBC SQL 7 ODBC FileMaker SQL FileMaker FileMaker Server Advanced FileMaker /

22 4 ODBC FileMaker 22 Oracle ODBC SQL Server ODBC FileMaker ODBC Oracle Microsoft SQL Server FileMaker ODBC ODBC ODBC FileMaker 1 Microsoft Word 1 Microsoft Excel 1 FileMaker Microsoft SQL Server DBMS 1 FileMaker 1 FileMaker Pro Microsoft Visual Basic FileMaker FileMaker Pro [ODBC/JDBC ] FileMaker Server Advanced FileMaker Pro ODBC/JDBC FileMaker Pro FileMaker Server FileMaker ODBC FileMaker 12 FileMaker 12 ODBC FileMaker xdbc Listener Mac OS Windows FileMaker xdbc Listener fmxdbc_listener FileMaker xdbc Listener FileMaker Server

23 4 ODBC FileMaker 23 FileMaker ODBC SQL FileMaker SQL ODBC FileMaker 1. FileMaker Pro [ODBC/JDBC ] 2. FileMaker Server AdvancedFileMaker Server Admin Console FileMaker Pro ODBC/JDBC FileMaker Server Admin Console [ODBC/JDBC] [ODBC/JDBC ] FileMaker Pro [ ] > [ ] > [ODBC/JDBC...] [ODBC/JDBC ] [ ] 3. FileMaker FileMaker FileMaker 4. FileMaker 5. SQL FileMaker FileMaker DSN FileMaker Windows FileMaker FileMaker DSN ODBC Windows FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker ODBC 16 Windows ODBC Windows ODBC ODBC ODBC ODBC

24 4 ODBC FileMaker Windows 32 ODBC Windows [ ] > [ (ODBC)] 1 Windows XP [ ] [ ] 1 Windows Vista Windows 7 [ ] [ ] 32 [ODBC ] 64 Windows 32 ODBC 1. SysWoW64SysWoW64 c:windowssyswow64 2. odbcad32.exe 32 [ODBC ] 64 Windows 64 ODBC Windows [ ] > [ (ODBC)] 1 Windows XP [ ] [ ] 1 Windows Vista Windows 7 [ ] [ ] 64 [ODBC ] ODBC 1. [ODBC ] [ DSN] [ DSN] 2. FileMaker [ ] [ ] [FileMaker ODBC] 3. [...] [FileMaker DSN ] 4. [ ] FileMaker [ ] FileMaker [ ] 5. [ ] FileMaker Pro FileMaker localhost FileMaker Server Advanced FileMaker FileMaker Server IP ODBC/JDBC [ ]

25 4 ODBC FileMaker [ ] FileMaker FileMaker Server Advanced [ ] FileMaker Server [ ] [ ] 1 [ ] 1 [ ] MS Word 255 PHP [ long varchar ] [ ] 7. [ ] 8. [ ] [FileMaker DSN ] ODBC Windows FileMaker ODBC 1. Windows [ ] > [ (ODBC)] 1 Windows XP [ ] [ ] 1 Windows Vista Windows 7 [ ] [ ] [ODBC ] 2. [ DSN] [ DSN] 3. FileMaker [ ] [ ] [FileMaker ODBC] 4. [...] [FileMaker DSN ] 5. [ ] [ ] 6. [ ] FileMaker [ ] [ ]

26 4 ODBC FileMaker 26 1 FileMaker 1 1 FileMaker [ODBC/JDBC ] 1 FileMaker Pro FileMaker Server ODBC/JDBC Mac OS FileMaker FileMaker DSN ODBC Mac OS FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker ODBC 19 Mac OS ODBC Mac OS FileMaker Actual Technologies ODBC Manager Apple ODBC Administrator Tool for Mac OS X Mac OS X 10.6 ODBC Administrator ODBC ODBC FileMaker DSN ODBC ODBC 1. ODBC Manager ODBC Manager 2. [ DSN] [ DSN] 3. FileMaker [ ] [ ] [FileMaker ODBC] 4. [...] [FileMaker DSN ] 5. [ ] 6. [ ] FileMaker [ ]

27 4 ODBC FileMaker [ ] FileMaker Pro FileMaker localhost FileMaker Server Advanced FileMaker FileMaker Server IP ODBC/JDBC [ ] 8. [ ] FileMaker FileMaker Server Advanced [ ] FileMaker Server [ ] [ ] 1 [ ] 1 [ ] MS Word 255 PHP [ long varchar ] [ ] 9. [ ] 10. [ ] [FileMaker DSN ] ODBC Mac OS FileMaker ODBC 1. ODBC Manager ODBC Manager 2. [ DSN] [ DSN] 3. FileMaker [ ] [ ] [FileMaker ODBC] 4. [...] [FileMaker DSN ]

28 4 ODBC FileMaker [ ] [ ] 6. [ ] FileMaker [ ] [ ] 1 FileMaker 1 1 FileMaker [ODBC/JDBC ] 1 FileMaker Pro FileMaker Server ODBC/JDBC

29 5 FileMaker JDBC JDBCJava Database Connectivity FileMaker FileMaker DVDxDBC URL FileMaker Server Advanced FileMaker FileMaker SQL JDBC FileMaker JDBC FileMaker JDBC JDK 1.4 Java Windows Mac OSjava -version FileMaker TCP/IP JDBC JDBC JDBC 1. 1 Windows.exe 1 Mac OS.dmg 1 2. FileMaker Pro FileMaker Server xdbc 3. xdbcjdbc Client Driver Installer

30 5 FileMaker JDBC fmjdbc.jar 1 Windowsfmjdbc.jar Java java.exe Java ClassPath 1 Mac OSfmjdbc.jar/ /Java/Extensions Java ClassPath FileMaker JDBC JDBC JDBC Java JDBC JDBC URL FileMaker JDBC JDBC JDBC 6 JDBC FileMaker

31 6 JDBC FileMaker Java JDBC RADRapid Application Development FileMaker Java JDBC Java FileMaker JDBC JDBC SQL Java API JDBC Java ODBC Java Database Connectivity JDBC JDBC SQL JDBC Java FileMaker SQL FileMaker FileMaker Server Java FileMaker / Java JDBC FileMaker JDBC Java Java RAD JDBC Java JDBC JDBC JDBC Java JDBC URL JDBC URL

32 6 JDBC FileMaker 32 JDBC JDBC JDBC 3.0 FileMaker Ref 1 CLOBARRAY REF 1 1 DATALINK 1 1 JDBC SPI JDBC Java Development Kit (JDK) 1.5 (Mac OS) 1.6 (Windows) FileMaker JDBC Java JDBC Java com.filemaker.jdbc.driver FileMaker FileMaker JDBC JDBC FileMaker FileMaker xdbc Listener Mac OS Windows FileMaker xdbc Listener fmxdbc_listener FileMaker xdbc Listener FileMaker Server

33 6 JDBC FileMaker 33 JDBC URL Java URLUniform Resource LocatorJDBC URL JDBC jdbc:< >:< > JDBC URL JDBC jdbc< > JDBC < > filemaker < > FileMaker IP JDBC FileMaker JDBC 1. JDBC JDBC 2. FileMaker JDBC URL jdbc:filemaker:// /database 3. import java.sql.*; class FMPJDBCTest { public static void main(string[ ] args) { // register the JDBC client driver try { Driver d = (Driver)Class.forName("com.filemaker.jdbc.Driver").newInstance(); } catch(exception e) { System.out.println(e); } // establish a connection to FileMaker Connection con; try { con = DriverManager.getConnection("jdbc:filemaker:// /mydatabase","username", "password"); } catch (Exception e) { System.out.println(e); } // get connection warnings SQLWarning warning = null; try { warning = con.getwarnings(); if (warning == null) { System.out.println("No warnings"); return; } while (warning!= null) { System.out.println("Warning:"+warning); warning = warning.getnextwarning();

34 6 JDBC FileMaker 34 } } } } catch (Exception e) { Sysem.out.println(e); } URL user password JDBC URL DriverManager.GetConnection 1 user:[odbc/jdbc ] FileMaker 1 password:filemaker URL JDBC URL jdbc:filemaker://<filemaker IP >/< > jdbc:filemaker:// /publications URL JDBC URL jdbc:filemaker://<filemaker IP >/< >?user=< > &password=< > jdbc:filemaker:// /customers?user=collections&password=admin & jdbc:filemaker://localhost/sales_db?user=ad&min&password=admin jdbc:filemaker://localhost/sales_db?user=admin1&password=ad&min

35 6 JDBC FileMaker 35 FileMaker JDBC URL FileMaker JDBC JDBC FileMaker 1 FileMaker 1 FileMaker [ODBC/JDBC ] 1 FileMaker Pro FileMaker Server Advanced ODBC/JDBC FileMaker FileMaker Pro [ODBC/JDBC ] FileMaker Server Advanced FileMaker Pro ODBC/JDBC FileMaker Pro 1 JDBC JDBC URL Java JDBC FileMaker

36 7 FileMaker ODBC JDBC SQL ODBC JDBC FileMaker FileMaker FileMaker Pro FileMaker Server Advanced ODBC Level 2 ODBC 3.5 Level 1 JDBC JDBC ODBC JDBC SQL- 92 SQL-92 Unicode ODBC JDBC Unicode API Unicode ASCII Unicode SQL_C_WCHAR SQL ODBC JDBC SQL 1 SELECT 1 DELETE43 1 INSERT43 1 UPDATE44 1 CREATE TABLE45 1 ALTER TABLE46 1 CREATE INDEX46 1 DROP INDEX47 FileMaker ODBC SQL JDBC SQL 60 FileMaker ODBC 60 FileMaker JDBC SQL ODBC JDBC FileMaker ""

37 7 37 SELECT SELECT SELECT * 1.05 SELECT SELECT [DISTINCT] {* [[AS] ],...} FROM [ ],... [ WHERE 1 2 ] [ GROUP BY {,...} ] [ HAVING 1 2 ] [ UNION [ALL] (SELECT...) ] [ ORDER BY { [DESC ASC]},...] [ FOR UPDATE [OF {,...} ] ] [] SELECT " " AS " " FROM " ".. DISTINCT SELECT DISTINCT " " FROM " " SQL ODBC JDBC SQL SQL FROM37 WHERE38 GROUP BY39 HAVING39 UNION39 ORDER BY40 SELECT FileMaker Pro FileMaker Pro 20,000,000 SELECT FOR UPDATE40 SQL SELECT FROM FROM SELECT FROM [ ] [, [ ]]

38 7 38 FROM E E. SELECT SELECT * FROM " " "E", " " "F" WHERE "E"." " = "F"." " = INNER JOIN SELECT * FROM " " INNER JOIN " " ON " "." " = " "." " LEFT JOIN SELECT * FROM " " LEFT JOIN " " ON " "." " = " "." " RIGHT JOIN SELECT * FROM " " RIGHT JOIN " " ON " "." " = " "." " 1 LEFT JOIN LEFT OUTER JOIN 1 RIGHT JOIN RIGHT OUTER JOIN 1 FULL OUTER JOIN WHERE WHERE WHERE WHERE SELECT 2,000,000 SELECT " "," " FROM " " WHERE " " >= WHERE WHERE 1 IS NULL WHERE NOT 2 SELECT WHERE

39 7 39 GROUP BY GROUP BY GROUP BY SELECT SELECT " ", SUM ( " " ) FROM " " GROUP BY " " HAVING HAVING 20,000,000 HAVING SELECT 20,000,000 SELECT " ", SUM ( " " ) FROM " " GROUP BY " " HAVING SUM ( " " ) > UNION UNION SELECT SELECT ALL UNION ALL SELECT UNION [ALL] SELECT UNION SELECT SELECT " ", " ", " " FROM " " UNION SELECT " ", " ", " " FROM " " SELECT SELECT " ", " " FROM " " UNION SELECT " ", " " FROM " "

40 7 40 ORDER BY ORDER BY ORDER BY { [DESC ASC]},... ASC SELECT SELECT " ", " ", " " FROM " " ORDER BY " ", " " SELECT " ", " ", " " FROM " " ORDER BY 2, 3 2 SELECT ORDER BY 2 FOR UPDATE FOR UPDATE SQL FOR UPDATE [OF ] 2,000,000 SELECT * FROM " " WHERE " " > FOR UPDATE OF " ", " ", " "

41 7 41 SQL SELECT 'CatDog' FROM " " SELECT 999 FROM " " SELECT DATE ' ' FROM " " SELECT TIME '02:49:03' FROM " " SELECT TIMESTAMP ' :49:03' FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " BLOB a SELECT " " FROM " " SELECT GETAS(" ", 'JPEG') FROM " " * SELECT * FROM " " SELECT DISTINCT * FROM " " a. BLOB FileMaker FileMaker *SELECT * FROM " " SELECT DISTINCT * FROM " " 1 FileMaker SELECT * FROM WHERE c = SELECT * FROM WHERE c <> 1 SELECT GetAs() CAST() GetAs() CAST() GetAs() SELECT SELECT " " FROM " " JPEG SELECT SELECT < >

42 7 42 Quicktime SELECT CAST() SELECT CAST(" " AS VARCHAR("NNN")) FROM " " 1 FileMaker Pro SELECT SQL_VARCHAR 1 FileMaker Pro SELECT 1 SELECT?FileMaker Pro.dat GetAs() FileMaker Pro 1 [ ] > [...] GetAs() FILE SELECT GetAs(" ", 'FILE') FROM " " 1 [ ] > [...] - Mac OS GetAs() snd SELECT GetAs(" ", 'snd ') FROM " " 1 [ ] > [...] SELECT GetAs(" ", 'JPEG') FROM " " 'EMF+' Windows Enhanced Metafile Plus 'PDF ' Portable Document Format 'EPS ' Embedded PostScript 'PICT' Mac OS512- 'FPix' FlashFPX 'PNGf' Bitmap 'FORK' Mac OS 'PNTG' MacPaint 'GIFf' Graphics Interchange Format 'qtif' QuickTime 'JPEG' '.SGI' 'JP2 ' JPEG 2000 'TIFF' 'META' Windows 'TPIC' Targa 'METO' Windows 'XMLO' 'moov' QuickTime Mac OS '8BPS' PhotoShop (PSD)

43 7 43 DELETE DELETE DELETE DELETE FROM [ WHERE { } ] WHERE WHERE DELETE DELETE FROM " " WHERE " " = 'E10001' DELETE WHERE E10001 INSERT INSERT 1 1 SELECT INSERT INSERT INTO [(,...)]VALUES (,...) [, VALUES (,...)] VALUES [4] ' 'Don''t' () INSERT INTO " " ( " ", " ", " ", " ", " ") VALUES (' ', ' ', 'E22345', , {2008/06/05}) INSERT INSERT PutAs() PutAs(col, 'type')41 CAST() GetAs()

44 7 44 SELECT SELECT INSERT SELECT INSERT INSERT INTO " 1" ( " ", " ", " ", " ", " ") SELECT " ", " ", " ", " ", " " FROM " " WHERE " " = ' ' INSERT SELECT INSERT SELECT SELECT INSERT INSERT/UPDATE ODBC JDBC SELECT INSERT SELECT UPDATE UPDATE UPDATE UPDATE SET =,...[ WHERE { } ] ' 'Don''t' () WHERE UPDATE UPDATE " " SET " " =32000, " " =1 WHERE " " = 'E10001' UPDATE WHERE E10001 UPDATE " " SET " " = (SELECT avg( " " ) from " " ) WHERE " " = 'E10001' E10001 UPDATE PutAs() PutAs(col, 'type')41 CAST() GetAs()

45 7 45 CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE ( [,...]) [DEFAULT ][UNIQUE][NOT NULL] [EXTERNAL [SECURE OPEN ]] 1 [4] 1 NUMERICDECIMALINTDATETIMETIMESTAMP VARCHARCHARACTER VARYINGBLOBVARBINARYLONGVARBINARY BINARY VARYINGNUMERIC DECIMAL DECIMAL(10,0)TIME TIMESTAMP TIMESTAMP(6)VARCHAR CHARACTER VARYING VARCHAR(255) 1 DEFAULT USERUSERNAMECURRENT_USERCURRENT_DATECURDATE CURRENT_TIMECURTIMECURRENT_TIMESTAMP CURTIMESTAMP 1 UNIQUE FileMaker [ ] 1 NOT NULL FileMaker [ ] FileMaker Pro [ ] [ ] [ ] 1 BLOBVARBINARY BINARY VARYING 1 EXTERNAL FileMaker FileMaker Pro [ ] SECURE OPEN FileMaker NOT NULL SQL CREATE TABLE "T1" ("C1" VARCHAR, "C2" VARCHAR (50), "C3" VARCHAR (1001), "C4" VARCHAR (500276)) CREATE TABLE "T1NN" ("C1" VARCHAR NOT NULL, "C2" VARCHAR (50) NOT NULL, "C3" VARCHAR (1001) NOT NULL, "C4" VARCHAR (500276) NOT NULL) CREATE TABLE "T2" ("C1" DECIMAL, "C2" DECIMAL (10,0), "C3" DECIMAL (7539,2), "C4" DECIMAL (497925,301)) CREATE TABLE "T3" ("C1" DATE, "C2" DATE, "C3" DATE, "C4" DATE)

46 7 46 SQL CREATE TABLE "T4" ("C1" TIME, "C2" TIME, "C3" TIME, "C4" TIME) CREATE TABLE "T5" ( "C1" TIMESTAMP, "C2" TIMESTAMP, "C3" TIMESTAMP, "C4" TIMESTAMP) CREATE TABLE "T6" ("C1" BLOB, "C2" BLOB, "C3" BLOB, "C4" BLOB) CREATE TABLE "T7" ("C1" BLOB EXTERNAL 'Files/MyDatabase' SECURE) CREATE TABLE "T8" ("C1" BLOB EXTERNAL 'Files/MyDatabase' OPEN 'Objects') ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ADD [COLUMN] ALTER TABLE DROP [COLUMN] ALTER TABLE ALTER [COLUMN] SET DEFAULT ALTER TABLE ALTER [COLUMN] DROP DEFAULT ALTER TABLE SQL ALTER TABLE " " ADD " 1" VARCHAR ALTER TABLE " " DROP " 1" ALTER TABLE " "ALTER " " SET DEFAULT FileMaker ALTER TABLE " " ALTER " " DROP DEFAULT SET DEFAULT DROP DEFAULT CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX ON. CREATE INDEX ON ( ) CREATE INDEX FileMaker FileMaker [ ] [ ] FileMaker [ ] [ ] FileMaker [ ] [ ]

47 7 47 FileMaker CREATE INDEX CREATE INDEX ON. DROP INDEX DROP INDEX DROP INDEX DROP INDEX ON. DROP INDEX ON ( ) FileMaker SELECT FileMaker [ ] [ ] [ ] PREVENT INDEX CREATION SQL DROP INDEX ON " "." " SELECT AVG(" ") AVG(" " * 1.07) DISTINCT COUNT (DISTINCT " ")

48 7 48 SUM AVG COUNT MAX MIN SUM AVG COUNTCOUNT COUNT COUNT(*) MAX MIN SELECT SUM (" "." ") AS " " FROM " " SELECT AVG (" "." ") AS " " FROM " " SELECT COUNT (" "." ") AS " " FROM " " SELECT MAX (" "." ") AS " " FROM " " WHERE " "." " < SELECT MIN (" "." ") AS " " FROM " " WHERE " "." " > SQL SELECT WHERE HAVING ORDER BY

49 7 49 * ' 'Don''t' FileMaker {} ODBC/JDBC 1 {D ' '} 1 {T '14:35:10'} 1 {TS ' :35:10'} FileMaker (DTTS) FileMaker SQL-92 ISO 1 DATE 'YYYY-MM-DD' 1 TIME 'HH:MM:SS' 1 TIMESTAMP 'YYYY-MM-DD HH:MM:SS' ' ' 1.05 DATE ' ' { D ' ' } {06/05/2012} {06/05/12} ODBC/JDBC SQL-92 TIME '14:35:10' { T '14:35:10' } {14:35:10} TIMESTAMP ' :35:10' { TS ' :35:10'} {06/05/ :35:10} {06/05/12 14:35:10} FileMaker [ 4 ] ODBC/JDBC SQL-92 SELECT "column1" / 3.4E+7 FROM "table1" WHERE "calc" < 3.4E-6 * "column2"

50 */ ^ ** ' ' - - ' ' {D ' '} {D ' '} - - {D ' '} {D ' '} SELECT " ", " " + 30 AS " " FROM " " SELECT " ", " " - 30 AS " " FROM " " = <> > >= < <= LIKE NOT LIKE IS NULL

51 7 51 IS NOT NULL BETWEEN IN NOT IN EXISTS ANY ALL =<>>>=< <= =Any In =<>>>=< <= SELECT " "." " FROM " " WHERE " "." " = 'SP-1' SELECT " "." " FROM " " WHERE " "." " <> 125 SELECT " "." " FROM " " WHERE " "." " > SELECT " "." " FROM " " WHERE " "." " < '12:00:00' SELECT " "." " FROM " " WHERE " "." " LIKE '% ' SELECT " "." " FROM " " WHERE " "." " NOT LIKE '% ' SELECT " "." " FROM " " WHERE " "." " IS NULL SELECT " "." " FROM " " WHERE " "." " IS NOT NULL SELECT " "." " FROM " " WHERE " "." " BETWEEN 1 AND 10 SELECT COUNT(" "." ") AS " " FROM " " WHERE " "." " IN (50,250,100) SELECT COUNT(" "." ") AS " " FROM " " WHERE " "." " NOT IN (50,250,100) SELECT COUNT (" "." ") AS " " FROM " " WHERE " "." " NOT IN (SELECT " "." " FROM " " WHERE " "." " = 'SP-4') SELECT * FROM " " WHERE EXISTS (SELECT " "." " FROM " " WHERE " "." " IS NOT NULL) SELECT * FROM " " WHERE " "." " = ANY (SELECT " "." " FROM " " WHERE " "." " = 'SP-1') SELECT * FROM " " WHERE " "." " = ALL (SELECT " "." " FROM " " WHERE " "." " IS NULL)

52 7 52 AND OR = AND = 1 NOT NOT ( = AND = 1) SELECT * FROM " " WHERE " "." " NOT LIKE '% ' AND " "." " > SELECT * FROM " " WHERE (" "." " LIKE '% ' OR " "." " > ) AND " "." " = 'SP-1' FileMaker SQL

53 7 53 CHR ASCII CHR(67) C CURRENT_USER DAYNAME ID RTRIM RTRIM(' ABC ') ABC TRIM TRIM(' ABC ') ABC LTRIM LTRIM(' ABC') ABC UPPER UPPER('Allen'ALLEN LOWER LOWER('Allen') allen LEFT LEFT('Mattson',3Mat MONTHNAME RIGHT RIGHT(Mattson', 4) tson SUBSTR SUBSTRING SUBSTR('Conrad', 2, 3) onr SUBSTR('Conrad', 2) onrad SPACE SPACE(5) STRVAL STRVAL('Woltman') Woltman STRVAL(5 * 3) 15 STRVAL(4 = 5) False STRVAL({D ' '}) TIME TIMEVAL USERNAME USER ID 9:49 TIME() 21:49:00 TIME() SQL CURRENT_TIME SELECT CHR(67) + SPACE(1) + CHR(70) FROM " " SELECT RTRIM(' ' + " "." ") AS " " FROM " " SELECT TRIM(SPACE(1) + " "." ") AS " " FROM " " SELECT LTRIM(' ' + " "." ") AS " " FROM " " SELECT UPPER(" "." ") AS " " FROM " " SELECT LOWER(" "." ") AS " " FROM " " SELECT LEFT(" "." ", 5) AS " " FROM " " SELECT RIGHT(" "." ", 7) AS " " FROM " " SELECT SUBSTR(" "." ", 2, 2) + SUBSTR(" "." ", 4, 2) AS " " FROM " " SELECT SUBSTR(" "." ", 2) + SUBSTR(" "." ", 4) AS " " FROM " " SELECT SPACE(2) + " "." " AS " " FROM " " SELECT STRVAL('60506') AS " " FROM " " WHERE " "." " = 1

54 7 54 ABS ATAN ATAN2 x y B 10 B'1001' 9 CEIL CEILING DEG DEGREES DAY DAY({d '2012/01/30'}) 30 DAYOFWEEK DAYOFWEEK({d '2004/05/01'}) 7 MOD MOD(10, 3) 1 EXP FLOOR HOUR (e) INT INT(6.4321) 6 LEN LENGTH LEN('ABC') 3 MONTH MONTH({d '2012/01/30'}) 1 LN LOG MAX MAX(66, 89) 89 MIN MIN(66, 89) 66 MINUTE NUMVAL PI RADIANS 0 pi NUMVAL('123') 123 ROUND ROUND(123,456.0) 123 ROUND( ,2) ROUND( , -2) 100 SECOND SIGN SIN SQRT TAN VAL - 0 VAL('123') 123

55 7 55 X X'b9' 185 YEAR DAY({d '2012/01/30'}) 2012 CURDATE CURRENT_DATE CURTIME CURRENT_TIME CURTIMESTAMP CURRENT_TIMESTAMP TIMESTAMPVAL DATE TODAY 2012/11/21 DATE() DATEVAL DATEVAL('2012/01/30') DATE() SQL CURRENT_DATE ^, ** 3 *, / 4 +, - 5 =, <>, <, <=, >, >=, Like, Not Like, Is Null, Is Not Null, Between, In, Exists, Any, All 6 Not 7 AND 8 OR WHERE " " > OR " " > {d 2008/01/30} AND " " = 'D101' AND D101 4,000,000 WHERE (" " > OR " " > {d 2008/01/30}) AND " " = 'D101' 4,000, D101

56 7 56 ODBC ODBC 1 SQLTables - 1 SQLColumns 1 SQLColumnPrivileges 1 SQLDescribeCol 1 SQLGetTypeInfo JDBC JDBC 1 getcolumns 1 getcolumnprivileges 1 getmetadata 1 gettypeinfo 1 gettables 1 gettabletypes SQL CREATE TABLE DEC create table t ("dec" numeric) ABSOLUTE ACTION ADD ALL ALLOCATE ALTER AND ANY ARE AS ASC ASSERTION AT AUTHORIZATION AVG BEGIN BETWEEN BINARY BIT BIT_LENGTH BLOB BOOLEAN BOTH BY CASCADE CASCADED CASE CAST CATALOG CHAR

57 7 57 CHARACTER CHARACTER_LENGTH CHAR_LENGTH CHECK CHR CLOSE COALESCE COLLATE COLLATION COLUMN COMMIT CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTINUE CONVERT CORRESPONDING COUNT CREATE CROSS CURDATE CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CURTIME CURTIMESTAMP DATE DATEVAL DAY DAYNAME DAYOFWEEK DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DESC DESCRIBE DESCRIPTOR DIAGNOSTICS DISCONNECT DISTINCT DOMAIN DOUBLE DROP ELSE END END_EXEC ESCAPE EVERY EXCEPT EXCEPTION EXEC EXECUTE EXISTS EXTERNAL EXTRACT FALSE FETCH FIRST FLOAT FOR FOREIGN FOUND FROM FULL GET GLOBAL GO GOTO GRANT GROUP HAVING HOUR IDENTITY IMMEDIATE IN INDEX INDICATOR INITIALLY INNER INPUT INSENSITIVE NSERT INT INTEGER INTERSECT INTERVAL INTO IS

58 7 58 ISOLATION JOIN KEY LANGUAGE LAST LEADING LEFT LENGTH LEVEL LIKE LOCAL LONGVARBINARY LOWER LTRIM MATCH MAX MIN MINUTE MODULE MONTH MONTHNAME NAMES NATIONAL NATURAL NCHAR NEXT NO NOT NULL NULLIF NUMERIC NUMVAL OCTET_LENGTH OF ON ONLY OPEN OPTION OR ORDER OUTER OUTPUT OVERLAPS PAD PART PARTIAL POSITION PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIVILEGES PROCEDURE PUBLIC READ REAL REFERENCES RELATIVE RESTRICT REVOKE RIGHT ROLLBACK ROUND ROWID ROWS RTRIM SCHEMA SCROLL SECOND SECTION SELECT SESSION SESSION_USER SET SIZE SMALLINT SOME SPACE SQL SQLCODE SQLERROR SQLSTATE STRVAL SUBSTRING SUM SYSTEM_USER TABLE TEMPORARY THEN TIME TIMESTAMP TIMESTAMPVAL TIMEVAL TIMEZONE_HOUR TIMEZONE_MINUTE

59 7 59 TO TODAY TRAILING TRANSACTION TRANSLATE TRANSLATION TRIM TRUE UNION UNIQUE UNKNOWN UPDATE UPPER USAGE USER USERNAME USING USAGE USER USERNAME USING VALUE VALUES VARBINARY VARCHAR VARYING VIEW WHEN WHENEVER WHERE WITH WORK WRITE YEAR ZONE

60 8 FileMaker ODBC FileMaker Pro ODBC FileMaker ODBC SQL_VARCHAR FileMaker [ ] 100 FileMaker NULL SQL_DOUBLE FileMaker SQL_DATE SQL_TIME FileMaker 24 0 SQL_TIMESTAMP BLOB SQL_LONGVARBINARY SELECT CAST() GetAs() ODBC Unicode FileMaker INSERT INTO "mytable"("repfield"[3]) VALUES ('this is rep 3') SELECT "repfield"[1], "repfield"[2] FROM "mytable" FileMaker JDBC JDBC FileMaker JDBC SQL JDK 1.5 Web FileMaker JDBC SQL java.sql.types.varchar java.sql.types.double java.sql.types.date java.sql.types.time java.sql.types.timestamp java.sql.types.blob

61 8 61 FileMaker JDBC JDBC SQL FileMaker JDBC java.sql.types.timestamp 64 ODBC API Windows ODBC API ODBC JDBC FileMaker ODBC/JDBC ODBC 1 ODBC 1 FileMaker FileMaker xdbc Listener FileMaker ODBC FileMaker Listener [FileMaker] [FileMaker ODBC] FileMaker [FileMaker] [FileMaker ODBC] Invalid Username/Password FileMaker JDBC FileMaker JDBC SQLException 1 JDBC 1 FileMaker FileMaker xdbc Listener

62 8 62 FileMaker JDBC FileMaker Listener [FileMaker] [FileMaker JDBC] FileMaker [FileMaker] [FileMaker JDBC] Invalid Username/Password FileMaker

63 A ABS 54 ALL 51 ALTER TABLE (SQL )46 AND 52 ANY 51 ARRAY 32 ATAN2 54 ATAN 54 B BETWEEN 51 BLOB SELECT 41 B 54 C CAST 4260 CEILING 54 CEIL 54 CHR 53 CLOB 32 CREATE INDEX (SQL )46 CREATE TABLESQL 45 CURDATE 55 CURRENT_DATE 55 CURRENT_TIMESTAMP 55 CURRENT_TIME 55 CURRENT_USER 53 CURRENT USER 53 CURTIMESTAMP 55 CURTIME 55 D DATALINK 32 DATEVAL 55 DATE 55 DAYNAME 53 DAYOFWEEK 54 DAY 54 DEFAULT (SQL )45 DEGREES 54 DEG 54 DELETESQL 43 DISTINCT 37 DROP INDEX SQL 47 DSN Mac OS26 Windows23 9 E ExecuteSQL 11 EXISTS 51 EXP 54 EXTERNAL (SQL )45 F FileMaker 8 FileMaker JDBC 34 ODBC Mac OS26 ODBC Windows23 FLOOR 54 FOR UPDATESQL 40 FROMSQL 37 FULL OUTER JOIN38 G GetAs 4260 GROUP BYSQL 39 H HAVINGSQL 39 HOUR 54 I INNER JOIN38 INSERTSQL 43 INT 54 IN 51 IS NOT NULL 51 IS NULL 50 J Java JDK32 Java 29 JDBC JDBC SPI32

64 64 JDBC JDBC URL 33 JDBC 33 Unicode JDBC URLUniform Resource Locator33 JDBC 33 JDBC 56 L LEFT JOIN38 LEFT OUTER JOIN38 LEFT 53 LEN 54 LIKE 50 LN 54 LOG 54 LOWER 53 LTRIM 53 M Mac OS DSN 26 JDBC 29 ODBC 27 ODBC 14 MAX 54 MINUTE 54 MIN 54 MOD 54 MONTHNAME 53 MONTH 54 N NOT IN 51 NOT LIKE 50 NOT NULLSQL 45 NOT 52 NUMVAL 54 O ODBC ODBC/JDBC 23 ODBC Mac OS27 ODBC Unicode 36 Mac OS27 Windows ODBC Windows26 ODBC 56 ORDER BYSQL 40 OR 52 OUTER JOIN38 P PI 54 PREVENT INDEX CREATION47 R RADIANS 54 Rapid Application Development (RAD) 31 REF 32 RIGHT JOIN38 RIGHT OUTER JOIN38 RIGHT 53 ROUND 54 RTRIM 53 S SECOND 54 SELECTSQL 37 BLOB SIGN 54 SIN 54 SPACE 53 SQL_C_WCHAR 36 SQL-9236 SQLExceptions61 SQL SQL 55 SQL 49 SQL 52 SQL 49 SQL 50 SQL 49

65 65 SQL 50 SQL 48 SQL 50 SQL 50 SQL 52 SQL ALTER TABLE46 CREATE INDEX46 CREATE TABLE45 DELETE43 DROP INDEX47 INSERT43 SELECT37 UPDATE SQL 47 SQL 48 SQL 36 SQL 11 SQRT 54 STRVAL 53 SUBSTRING 53 SUBSTR 53 T TAN 54 TIMESTAMPVAL 55 TIMEVAL 53 TIME 53 TODAY 55 TRIM 53 U Unicode 36 UNIONSQL 39 UNIQUE (SQL )45 UPDATE (SQL )44 UPPER 53 USERNAME 53 V VALUES SQL 43 VAL 54 W WHERESQL 38 Windows DSN 23 JDBC 29 ODBC 25 ODBC 14 X Y YEAR JDBC 35 ODBC Mac OS27 ODBC Windows25 JDBC 35 ODBC Mac OS27 ODBC Windows CREATE TABLE 4546 INSERT 43 JDBC 60 ODBC 60 SELECT 41 UPDATE QuickTime JDBC32 ODBC40 FileMaker ODBC JDBC SELECT 41 SQL56 ODBC/JDBC 23 FileMaker 8 X 55

66 66 50 FileMaker JDBC 35 JDBC 34 ODBC Mac OS27 ODBC Windows25 ODBC Mac OS26 ODBC Windows23 FileMaker DSN9 FileMaker 8 DSN JDBC 60 ODBC 60 DSN SQL47 9 JDBC 34 ODBC Mac OS26 ODBC Windows SELECT 41 JDBC34 ODBC JDBC 60 ODBC JDBC DSN SQL