FileMaker ODBC and JDBC Guide

Transcription

1 FileMaker 10 ODBC JDBC

2 FileMaker, Inc. All rights reserved. FileMaker, Inc Patrick Henry Drive Santa Clara, California FileMaker Bento Bento FileMaker, Inc. Mac Mac Apple Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgements URL 01

3 1 7 7 FileMaker 7 FileMaker Pro FileMaker ODBC JDBC ODBC Windows 11 ODBC Mac OS 11 JDBC ODBC Windows 12 ODBC Mac OS 13 JDBC Windows Mac OS ODBC FileMaker 15 ODBC 15 ODBC 16 FileMaker 16 Windows FileMaker 17 FileMaker DSN ODBC Windows 17 ODBC Windows 18 Mac OS FileMaker 19 ODBC Mac OS 19 FileMaker DSN ODBC Mac OS 19 4 JDBC FileMaker 21 JDBC 21 JDBC 21 JDBC 21

4 4 FileMaker ODBC JDBC JDBC URL 22 URL 23 JDBC Unicode 27 SQL 27 SELECT 27 SQL 28 FROM 29 WHERE 29 GROUP BY 29 HAVING 29 UNION 30 ORDER BY 30 FOR UPDATE 30 DELETE 33 INSERT 33 UPDATE 34 CREATE TABLE 34 ALTER TABLE 35 CREATE INDEX 36 DROP INDEX 36 SQL 36 SQL ODBC 42 JDBC 43 SQL 43

5 5 6 FileMaker ODBC 45 7 FileMaker Pro JDBC 47 8 ODBC JDBC 49 ODBC 49 ODBC 49 ODBC 49 SequeLink Client 49 SequeLink Server JDBC 50 JDBC 50 SequeLink Server

6 6 FileMaker ODBC JDBC

7 1 ODBCOpen Database Connectivity JDBCJava Database Connectivity FileMaker ODBC JDBC FileMaker Pro FileMaker Server Advanced ODBCJDBC SQL FileMaker ProFileMaker Pro Advanced FileMaker Server Advanced FileMaker ODBC JDBC FileMaker ODBC JDBC FileMaker ODBC FileMaker Pro FileMaker Pro FileMaker ODBC JDBC FileMakerPro / FileMakerPro 1. SQL 2. ODBC JDBC FileMakerPro ODBC / ODBC ODBC [ ] [] [ ] [SQL ] FileMaker Pro 1 FileMaker Pro ODBC JDBC 1 ODBC JDBC SQL 1 FileMaker Pro Advanced FileMaker ProFileMaker Pro FileMaker Pro Advanced FileMaker FileMaker ODBC JDBC API API FileMaker Pro FileMaker Server Advanced ODBC JDBC SQL SQL FileMaker SQL ODBC JDBC FileMaker SELECT, FROM WHERE ='' INSERT INTO (, ) VALUES ('','')

8 8 FileMaker ODBC JDBC FileMaker Pro FileMaker Server Advanced FileMaker Pro FileMaker ODBC JDBC FileMaker FileMaker FileMaker Server Advanced FileMaker Pro 50 Web ODBC JDBC FileMaker Server Advanced FileMaker Pro FileMaker ODBC ODBC FileMaker 2 FileMaker ODBC JDBC FileMaker FileMaker ODBC JDBC FileMaker Pro FileMaker Server Advanced SQL 5 ODBC/JDBC FileMaker Server Advanced FileMaker Pro ODBC JDBC FileMaker FileMaker 1 Microsoft Query : FileMaker ASCII Microsoft Query 1 Microsoft Access: FileMaker ASCII FileMaker Server Advanced FileMaker TCP/IP FileMaker Pro FileMaker Server 9 Advanced FileMaker Pro FileMaker ODBC JDBC

9 1 9 FileMaker DSN DSN FileMaker DSN

10 10 FileMaker ODBC JDBC

11 2 FileMaker ODBC JDBC ODBCOpen Database Connectivity JDBCJava Database Connectivity FileMaker FileMaker CD xdbc FileMaker Server Advanced FileMaker FileMaker SQL ODBC JDBC FileMaker ODBC JDBC FileMaker ODBC JDBC ODBC Windows 1 Pentium 300 MHz 1 RAM : Windows MBWindows XP 128 MB 1 Microsoft Data Access ComponentsMDAC2.8 SP1 1 Windows MDAC 6.0 for Vista ODBC Mac OS 1 Apple G3 G3 1 RAM : 128 MB 1 Mac OS X FileMaker

12 12 FileMaker ODBC and JDBC Guide JDBC API JDBC 1.22 API JDBC 2.0 Core API JDBC 2.0 Optional Package JCA API JDK 1.3 JDK 1.2 JVMJava JDK 1.3 JVM JDK 1.3 JVM JDBC 3.0 API JDK API SequeLink Java 1 JDBC 2.0 Optional Package 1 JNDI JTA Java Windows Mac OSjava -version FileMaker TCP/IP ODBC Windows Windows ODBC [] ODBC ODBC MDAC 2.8 SP1 MDAC 1. xdbcodbc Client Driver Installer [setup] DataDirect SequeLink for ODBC InstallShield Wizard 2. ODBC Data Source SyncToolData Source SyncTool Administrator SequeLink Online Books ODBC ODBC C:Program FilesDataDirectslodbc55 3. [Finish] ODBC DataDirect 32-BIT SequeLink 5.5FileMaker Windows [] [] [ ] []

13 2 FileMaker ODBC JDBC 13 ODBC Mac OS Mac OS ODBC ODBC xdbcodbc Client Driver InstallerSequeLink.bundle ODBC SequeLink.bundle /Library/ODBC /Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk20.dylib /Users/<>/Library/ODBC /Users/<>/Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk20.dylib /ODBC ODBC 1 rootadmin 1 rootadmin / / 1 / ODBC Administrator 1.0.2Mac OS ODBC Administrator 1.1 Mac OS ODBC ODBC Administrator JDBC Windows Mac OS JDBC Windows Mac OS JDBC JDBC JDBC 1. xdbcjdbc Client Driver Installer [sljcinstaller.jar] [DataDirect SequeLink for JDBC 5.5 Installer] Java Runtime Environment.JAR WinZip Stuffit.JAR JDBC Installer Installer Windows Mac OSJDBC Client Driver java -jar sljcinstaller.jar 2. [Next] 3. [I accept the terms of the license agreement] [Next] 4. [Install Developer's Tools] JDBC JDBCTest 5. [Install Directory]

14 14 FileMaker ODBC and JDBC Guide 1 Windows: java java.exe 1 Mac OS: /Library/Java/Extensions java ClassPath 6. [Next] 7. [Install] 8. [Finish] FileMaker JDBC FileMaker FileMaker 2399ODBCWindows ODBC ODBCMac OS ODBC JDBC JDBC URL Windows ODBC Windows [] [] [DataDirect SequeLink for ODBC 5.5] [Driver Help] DataDirect Technologies ODBC JDBC FileMaker SQL FileMaker ODBC [Get external data] [SQL query]

15 3 ODBC FileMaker ODBC FileMaker ODBC FileMaker 1 Windows: FileMaker ODBC DataDirect 32-BIT SequeLink Mac OS: FileMaker ODBC ivslk20.dylib FileMaker Pro SQL ODBC ODBC FileMaker Pro ODBC ODBC API ODBC ODBC SQL SQL FileMaker ODBC SQL 5 ODBC FileMaker SQL FileMaker FileMaker Server Advanced FileMaker / Oracle ODBC SQL Server ODBC ODBC Oracle Microsoft SQL Server FileMaker

16 16 FileMaker ODBC JDBC 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 Pro ODBC ODBC FileMaker SequeLink Server Mac OS Activity Monitor Windows ddfmsoc FMSocket_SL55 SequeLink Server FileMaker Server 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

17 3 ODBC FileMaker 17 FileMaker FileMaker DSN FileMaker Windows Microsoft Access FileMaker ODBC Windows FileMaker FileMaker DSN ODBC Windows FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker ODBC 1. [ODBC ] Windows [] >[ (ODBC) ] Windows XP Windows Vista 2. [ DSN] DSN DSN 3. [...] [...] 6 4. [DataDirect 32-BIT SequeLink 5.5] [ODBC ] Regedit HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers () [] [] Regedit [ ] [] ODBC [ODBC ] 5. [] [ODBC DataDirect SequeLink Setup] [General] 6. [Data Source Name:] FileMaker [Description:] [Use LDAP] ODBC.DLL [Translate...] ODBC 7. [SequeLink Server Host:]

18 18 FileMaker ODBC JDBC FileMaker Pro FileMaker localhost FileMaker Server Advanced FileMaker FileMaker Server IP 8. [SequeLink Server Port:] 2399 FileMaker [SequeLink Server Port:] [Server Data Source:] FileMaker 10. ODBC/JDBC [Server Data Source] FileMaker %20 MY%20DATABASE 11. [OK] FileMaker [OK] [ODBC ] ODBC Windows FileMaker ODBC 1. [ODBC ] Windows [] >[ (ODBC)] Windows XP 2. [ DSN] DSN DSN 3. FileMaker [] [] [DataDirect 32-BIT SequeLink 5.5] 4. [...] [DataDirect SequeLink for ODBC Setup] 5. [Test Connect] FileMaker [Database User Name] [Database Password] Connection test was successful 1 FileMaker 1 1 FileMaker [ODBC/JDBC ] 1 FileMaker Pro FileMaker Server ODBC/JDBC

19 3 ODBC FileMaker 19 Mac OS FileMaker ODBC 3.51 ODBC Mac OS ODBC ODBC Administrator ODBC Administrator 1.0.2Mac OS ODBC Administrator 1.1 Mac OS SequeLink.bundle /Library/ODBC /Users/<>/Library/ODBC /Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk20.dylib /Users/<>/Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk20.dylib ODBC Administrator FileMaker DSN ODBC Mac OS FileMaker DSN DSN FileMaker ODBC FileMaker FileMaker Mac OS ODBC ASCII FileMaker ASCII ODBC/JDBC DSN DSN ServerDataSource FileMaker Pro FileMaker localhost FileMaker Server Advanced FileMaker FileMaker Server IP 2399 FileMaker %20 ServerDataDource=MY%20DATABASE

20 20 FileMaker ODBC JDBC

21 4 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 JDBC JDBC JDBC 3.0 FileMaker Blob Clob

22 22 FileMaker ODBC JDBC 1 Ref 1 BLOBCLOBARRAYREF 1 1 DATALINK 1 1 JDBC SPI JDBC SequeLink JDBC SequeLink Develolper's Reference JDBC Java Development Kit (JDK) (Mac OS) 1.6 (Windows) FileMaker JDBC Java JDBC Java Java 2 JDBC 1.2 JDK 1.3 Java 2 com.ddtek.jdbc.sequelink.sequelinkdriver FileMaker JDBC JDBC FileMaker SequeLink Server Mac OS Activity Monitor Windows ddfmsoc FMSocket_SL55 SequeLink Server FileMaker Server JDBC URL Java URLUniform Resource LocatorJDBC URL JDBC JDBC URL jdbc:<subprotocol>:<subname> JDBC URL JDBC jdbcsubprotocol JDBC subprotocol sequelink subname FileMaker IP

23 4 JDBC FileMaker 23 JDBC FileMaker JDBC 1. JDBC JDBC 2. FileMaker JDBC URL jdbc:sequelink:// : import java.sql.*; class FMPJDBCTest { public static void main(string[ ] args) { try { Driver d = (Driver)Class.forName("com.ddtek.jdbc.sequelink.SequeLinkDriver").newInstance(); } catch(exception e) { System.out.println(e); } Connection con; try { con = DriverManager.getConnction( jdbc:sequelink:// :2399; user=some user;password=some password;serverdatasource=database ); } catch(exception e) + ";serverdatasource=" + dbname{ System.out.println(e); } 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(); } } catch (Exception e) { Sysem.out.println(e); } } } URL user password JDBC URL Properties DriverManager.GetConnection 1 user: [ODBC/JDBC ] FileMaker

24 24 FileMaker ODBC JDBC 1 password: FileMaker JDBC URL : jdbc:sequelink://<sequelink IP >:<> FileMaker URL 2399 JDBC JDBC URL jdbc:sequelink:// localhost:2399 : jdbc:sequelink:// :2399 URL JDBC URL : jdbc:sequelink://<sequelink IP >:<>;user=<>;password=<> : jdbc:sequelink:// :2399;user=phil;password=jsp URL JDBC URL : jdbc:sequelink://<sequelink IP >:<>; serverdatasource=<> : jdbc:sequelink:// :2399;serverdatasource=publications %20 : jdbc:sequelink:// :2399;serverdatasource=my%20database

25 4 JDBC FileMaker 25 URL JDBC URL : jdbc:sequelink://<sequelink IP >: <>;serverdatasource=<>;dbuser=<>; > : jdbc:sequelink://<sequelink IP >: <>;serverdatasource=<>;huser=<>;hpassword=<> DBPassword=< JDBC URL FileMaker SSLSecure Socket Layer JDBC Web https FileMaker.ASP.JSP JDBC JDBC JDBCTest JDBC [Install Developer's Tools] JDBCTest JDBC Windows Mac OS 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

26 26 FileMaker ODBC JDBC

27 5 FileMaker ODBC JDBC SQL ODBC JDBC FileMaker FileMaker FileMaker Pro FileMaker Server Advanced ODBC Level 2 ODBC 3.5 Level 1 JDBC JDBC SequeLink Developer's ReferenceODBC JDBC SQL-92 SQL-92 Unicode ODBC JDBC Unicode API Unicode ASCII Unicode SQL_C_WCHAR SQL_C_BINARY SQL ODBC JDBC SQL SELECT DELETE (33 ) INSERT (33 ) UPDATE (34 ) CREATE TABLE (34 ) ALTER TABLE (35 ) CREATE INDEX (36 ) DROP INDEX (36 ) FileMaker ODBC SQL JDBC SQL 6 FileMaker ODBC 7 FileMaker Pro JDBC SQL ODBC JDBC FileMaker Pro 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 {,...}] ] []

28 28 FileMaker ODBC JDBC SELECT * SELECT SELECT AS FROM.. DISTINCT : SELECT DISTINCT FROM SQL ODBC JDBC SQL SQL FROM WHERE (29 ) GROUP BY (29 ) HAVING (29 ) UNION (29 ) ORDER BY (30 ) FOR UPDATE (30 ) SELECT FileMaker Pro FileMaker Pro 20,000,000 GROUP BY SELECT SQL SELECT

29 5 29 FROM FROM SELECT FROM [] FROM E E.SELECT : SELECT * FROM E, F WHERE E. = F. = INNER JOIN : SELECT * FROM INNER JOIN ON. =. OUTER JOIN WHERE WHERE WHERE WHERE SELECT 2,000,000 SELECT, FROM WHERE >= SELECT WHERE GROUP BY GROUP BY GROUP BY SELECT SELECT, SUM() FROM GROUP BY HAVING HAVING 20,000,000 GROUP BY HAVING SELECT

30 30 FileMaker ODBC JDBC 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 ORDER BY ORDER BY ORDER BY { [DESC ASC]},... ASC SELECT SELECT,, FROM ORDER BY, SELECT,, FROM ORDER BY 2,3 SELECT ORDER BY 2 FOR UPDATE FOR UPDATE SQL FOR UPDATE [OF ] 2,000,000 SELECT * FROM WHERE > FOR UPDATE OF,,

31 5 31 BLOB a * 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 SELECT FROM SELECT GETAS(, 'JPEG') FROM SELECT * FROM SELECT DISTINCT * FROM a. BLOB FileMaker FileMaker *SELECT * FROM SELECT DISTINCT * FROM SELECT * : CAST() GetAs() SELECT : SELECT FROM JPEG SELECT SELECT <> Quicktime SELECT CAST : SELECT CAST( AS VARCHAR(NNN)) FROM 1 FileMaker Pro SELECT SQL_VARCHAR

32 32 FileMaker ODBC JDBC 1 FileMaker Pro SELECT 1 SELECT '?' FileMaker Pro Untitled.dat GetAs FileMaker Pro 1 [ ] > [ ] GetAs : SELECT GetAs(, ' ') FROM 1 [ ] > [ ] ( Mac OS ) GetAs snd : SELECT GetAs(, 'snd') FROM 1 [ ] > [ ] (OLE ) GetAs EMBO : SELECT GetAs(, 'EMBO') 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)

33 5 33 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 ' : 'Don''t' {} :.T..F.() INSERT INTO (,,,, ) VALUES ('', '', 'E22345', , {2004/6/5}) INSERT INSERT

34 34 FileMaker ODBC JDBC 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' {} :.T..F.() WHERE UPDATE UPDATE SET =32000, =1 WHERE = 'E10001' UPDATE WHERE E10001 UPDATE SET = (SELECT avg() from ) WHERE = 'E10001' E10001 UPDATE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE [NOT NULL] 100 NOT NULL FileMaker [] FileMaker Pro [] [] []

35 5 35 NOT NULL BLOB SQL CREATE TABLE 1 ( 1 VARCHAR, 2 VARCHAR (50), 3 VARCHAR (1001), 4 VARCHAR (500276)) CREATE TABLE 1NN ( 1 VARCHAR NOT NULL, 2 VARCHAR (50) NOT NULL, 3 VARCHAR (1001) NOT NULL, 4 VARCHAR (500276) NOT NULL) CREATE TABLE 2 ( 1 DECIMAL, 2 DECIMAL (10,0), 3 DECIMAL (7539,2), 4 DECIMAL (497925,301)) CREATE TABLE 3 ( 1 DATE, 2 DATE, 3 DATE, 4 DATE) CREATE TABLE 4 ( 1 TIME, 2 TIME, 3 TIME, 4 TIME) CREATE TABLE 5 ( 1 TIMESTAMP, 2 TIMESTAMP, 3 TIMESTAMP, 4 TIMESTAMP) CREATE TABLE 6 ( 1 BLOB, 2 BLOB, 3 BLOB, 4 BLOB) ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ADD [COLUMN] ALTER TABLE DROP [COLUMN] ALTER TABLE SQL ALTER TABLE ADD 1 VARCHAR ALTER TABLE DROP 1

36 36 FileMaker ODBC JDBC CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX [ ][ON]. CREATE INDEX FileMaker FileMaker [ ] [] FileMaker [ ] [] FileMaker [ ] [] CREATE INDEX ON. DROP INDEX DROP INDEX DROP INDEX DROP INDEX [ON]. FileMaker SELECT FileMaker [ ] [] [] PREVENT INDEX CREATION DROP INDEX ON. SQL SELECT AVG() AVG( * 1.07) DISTINCT : COUNT (DISTINCT ) SQL

37 5 37 SUM AVG COUNT MAX MIN SUM() AVG() COUNT() COUNT 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. * :35:10 WYSIWIG ' : 'Don''t' {D ' '}{14:35:10}{TS ' :35:10'} {} SQL-92 ISO 1 DATE 'YYYY-MM-DD' 1 TIME 'HH:MM:SS'

38 38 FileMaker ODBC JDBC 1 TIMESTAMP 'YYYY-MM-DD HH:MM:SS' '' 1.05 DATE ' ' { D ' ' } { 2005/06/05 } { 05/06/05} TIME '14:35:10' { T '14:35:10' } {14:35:10} TIMESTAMP ' :35:10' { TS ' :35:10'} { 2005/06/05 14:35:10 } { :35:10} { 05/06/05 14:35:10 } FileMaker [:] [4].T..F. SELECT 1, 3.4E+7 FROM 1 WHERE < 3.4E-6 * 2 +-*/ ^ ** c ' - - c '

39 5 39 {2004/01/30} {2004/02/04} - - {2004/01/01} {2004/01/20} SELECT, + 30 AS FROM SELECT, - 30 AS FROM = <> > >= < <= LIKE NOT LIKE IS NULL IS NOT NULL BETWEEN IN NOT IN EXISTS ANY =<>>>=< <= =Any In ALL =<>>>=< <= 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

40 40 FileMaker ODBC JDBC 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) AND OR = AND = 1 NOT NOT ( = AND = 1) SELECT * FROM WHERE. NOT LIKE '%' AND. > 3000 SELECT * FROM WHERE (. LIKE '%' OR. > 3000) AND. = 'SP-1' ODBC JDBC SQL CHR ASCII CHR(67) C RTRIM RTRIM( 'ABC') ABC TRIM TRIM('ABC') ABC LTRIM LTRIM('ABC') ABC UPPER UPPER'Allen'ALLEN LOWER LOWER'Allen'allen LEFT LEFT'Mattson',3Mat RIGHT RIGHT(Mattson', 4) tson SUBSTR SUBSTR('Conrad', 2, 3) onr SUBSTR('Conrad', 2) onrad

41 5 41 SPACE SPACE(5) ' ' STRVAL STRVAL('Woltman') Woltman STRVAL(5 * 3) 15 STRVAL(4 = 5) 'False' STRVAL({2004/12/25}) 2004/12/25 TIME 9:49 TIME() 21:49:00 USERNAME ID 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 SELECT TIME() AS FROM WHERE. = 1 SELECT USERNAME() AS FROM WHERE. = 1 MOD MOD(10, 3) 1 LEN LEN('ABC') 3 MONTH MONTH({2004/01/30}) 1 DAY DAY({2004/01/30}) 30 YEAR YEAR({2004/01/30}) 2004 MAX MAX(66, 89) 89 DAYOFWEEK DAYOFWEEK({2004/05/01}) 7 MIN MIN(66, 89) 66 POW POW(7,2) 49 INT INT(6.4321) 6 X X'b9' 185 B 10 B'1001' 9 ROUND ROUND( ,0) returns 123 ROUND( , 2) ROUND( , -2) 100

42 42 FileMaker ODBC JDBC NUMVAL VAL 0 0 NUMVAL('123') 123 VAL('123') 123 DATE 2005/11/21 DATE() {2005/11/21} DATEVAL DATEVAL('2006/01/30') {2006/01/30} ^, ** 3 *, / 4 +, - 5 =, <>, <, <=, >, >=LikeNot LikeIs NullIs Not NullBetweenInExistsAnyAll 6 Not 7 AND 8 OR WHERE > OR > {2004/01/30} AND = 'D101' AND D101 4,000,000 : WHERE ( > OR > {2004/01/30}) AND = 'D101' 4,000, D101 ODBC ODBC 1 SQLTables - 1 SQLColumns 1 SQLColumnPrivileges 1 SQLDescribeCol 1 SQLGetTypeInfo

43 5 43 JDBC JDBC 1 getcolumns 1 getcolumnprivileges 1 getmetadata 1 gettypeinfo 1 gettables 1 gettabletypes SQL Create Table OID create table t ("oid" numeric) ABSOLUTE ACTION ADD AFTER ALIAS ALL ALLOCATE ALTER AND ANY ARE AS ASC ASSERTION ASYNC AT AUTHORIZATION AVG BEFORE BEGIN BETWEEN BIT BIT_LENGTH BOOLEAN BOTH BREADTH BY CALL CASCADE CASCADED CASE CAST CATALOG CHAR CHARACTER CHARACTER_LENGTH CHAR_LENGTH CHECK CHR CLOSE COALESCE COLLATE COLLATION COLUMN COLUMNS COMMIT COMPLETION CONCAT CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTINUE CONVERT CORRESPONDING COUNT CREATE CROSS CURDATE CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CURTIME CYCLE DATA DATE DAY DAYOFMONTH DAYOFWEEK DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DEPTH DESC DESCRIBE DESCRIPTOR DIAGNOSTICS DICTIONARY DISCONNECT DISTINCT DOMAIN DOUBLE DROP EACH ELSE ELSEIF END END_EXEC EQUALS ESCAPE EXCEPT EXCEPTION EXEC EXECUTE EXISTS EXTERNAL EXTRACT FALSE FETCH FIRST FLOAT FLOOR FOR FOREIGN FOUND FROM FULL GENERAL GET GLOBAL GO GOTO GRANT GROUP HAVING HOUR IDENTIFY

44 44 FileMaker ODBC JDBC IF IFNULL IGNORE IMMEDIATE IN INDEX INDICATOR INITIALLY INNER INPUT INSENSITIVE INSERT INT INTEGER INTERSECT INTERVAL INTO IS ISOLATION JOIN KEY LANGUAGE LAST LCASE LEADING LEAVE LEFT LEN LENGTH LESS LEVEL LIKE LIMIT LOCAL LOOP LOWER LTRIM MATCH MAX MIN MINUTE MOD MODIFY MODULE MONTH NAMES NATIONAL NATURAL NCHAR NEW NEXT NO NONE NOT NOW NULL NULLIF NUMERIC OBJECT OCTET_LENGTH OF OFF OID OLD ON ONLY OPEN OPERATION OPERATORS OPTION OR ORDER OTHERS OUTER OUTPUT OVERLAPS PAD PARAMETERS PARTIAL PENDANT POSITION POW POWER PRECISION PREORDER PREPARE PRESERVE PRIMARY PRIOR PRIVATE PRIVILEGES PROCEDURE PROTECTED PUBLIC RCASE READ REAL RECURSIVE REF REFERENCES REFERENCING RELATIVE REMOVE REPLACE RESIGNAL RESTRICT RETURN RETURNS REVOKE RIGHT ROLE ROLLBACK ROUND ROUTINE ROW ROWS RTRIM SAVEPOINT SCHEMA SCROLL SEARCH SECOND SECTION SELECT SENSITIVE SEQUENCE SESSION SESSION_USER SET SIGNAL SIMILAR SIZE SMALLINT SOME SPACE SQL SQLCODE SQLERROR SQLEXCEPTION SQLSTATE SQLWARNING STATISTICS STRUCTURE SUBSTR SUBSTRING SUM SYSTEM_USER TABLE TEMPORARY TEST THEN THERE TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO TRAILING TRANSACTION TRANSLATE TRANSLATION TRIGGER TRIM TRUE TYPE UCASE UNDER UNION UNIQUE UNKNOWN UPDATE UPPER USAGE USER USERNAME USING VALUE VALUES VARCHAR VARIABLE VARYING VIEW VIRTUAL VISIBLE WAIT WHEN WHENEVER WHERE WHILE WITH WITHOUT WORK WRITE YEAR ZONE

45 6 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 1 FileMaker SELECT 170 UPDATE FileMaker Pro ODBC FileMaker Pro Unicode 10 29

46 46 FileMaker ODBC JDBC

47 7 FileMaker Pro 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 FileMaker JDBC JDBC SQL FileMaker JDBC java.sql.types.timestamp

48 48 FileMaker ODBC JDBC

49 8 ODBC JDBC FileMaker ODBC/JDBC FileMaker FileMaker Pro Get ( ) Get ( ODBC ) ODBC 1 ODBC 1 ODBC 1 SequeLink Client 1 SequeLink Server 1 ODBC SequeLink ODBC : [DataDirect] [ODBC SequeLink driver] [DataDirect] [ODBC SequeLink driver] Invalid precision specified ODBC ODBC ODBC ODBC : [Microsoft] [ODBC Driver Manager] [Microsoft] [ODBC Driver Manager] ODBC SequeLink Client SequeLink ODBC Client : [DataDirect] [ODBC SequeLink driver] [SequeLink Client] [DataDirect] [ODBC SequeLink driver] [SequeLink Client] The specified transliteration module is not found SequeLink Server SequeLink Server : [DataDirect] [ODBC SequeLink driver] [SequeLink Server]

50 50 FileMaker ODBC JDBC [DataDirect] [ODBC SequeLink driver] [SequeLink Server] Only SELECT statements are allowed in this read-only connection. [DataDirect] [ODBC SequeLink driver] [] FileMaker [DataDirect] [ODBC SequeLink driver] [FileMaker] Invalid Username/Password FileMaker JDBC SequeLink for JDBC SQLException 1 JDBC 1 SequeLink Server 1 JDBC JDBC : [DataDirect] [SequeLink JDBC Driver] [DataDirect] [SequeLink JDBC Driver] Timeout expired JDBC JDBC SequeLink Server SequeLink Server [DataDirect] [SequeLink JDBC Driver] [SequeLink] SequeLink Server [DataDirect] [JDBC SequeLink driver] [SequeLink] [DataDirect] [SequeLink JDBC Driver] [] FileMaker [DataDirect] [SequeLink JDBC Driver] [FileMaker] Invalid Username/Password FileMaker

51 A AccessMicrosoftMicrosoft Access ALL 39 ALTER TABLESQL 35 AND 40 ANY 39 API 7 ARRAY 22 B BETWEEN 39 BLOB CREATE TABLE 35 JDBC 22 SELECT 31 B 41 C CAST 31, 45 CHR 40 CLOB 22 CREATE INDEXSQL 36 CREATE TABLESQL 34 D DATALINK 22 DATEVAL 42 DATE 42 DAYOFWEEK 41 DAY 41 DELETESQL 33 DISTINCT 28 DROP INDEXSQL 36 DSN Mac OS 19 Mac OS 19 Windows 17 9 E EXISTS 39 F FileMaker JDBC 23 ODBC Mac OS 19 ODBC Windows 17 FileMaker 7 FileMaker FileMaker 8 FOR UPDATESQL 30 FROMSQL 29 G Get aaa bbb 49 Get aaa bbb 49 GetAs 32, 45 GROUP BYSQL 29 H HAVINGSQL 29 I INNER JOIN 29 INSERTSQL 33 INT 41 J JAR 13 JDBC JDBC SPI 22 JDBC JDBC URL 22 JDBC 23 Unicode JDBC URLUniform Resource Locator 22 JDBC 23 JDBC 43 JDBCTest 13 Java Development KitJDK 22 Java 12 L LEFT 40 LEN 41 LIKE 39 LOWER 40 LTRIM 40

52 52 FileMaker ODBC JDBC M Mac OS DSN 19 JDBC 13 JDBC 12 ODBC Administrator 13, 19 ODBC 13 ODBC 11 MAX 41 Microsoft Access 8 17 Microsoft Query 8 MIN 41 MOD 41 MONTH 41 N NOT NULLSQL 34 NOT 40 NUMVAL 42 O ODBC ODBC Administrator (Mac OS) 13 ODBC AdministratorMac OS 19 ODBC FileMaker 45 Unicode 27 Windows 18 Mac OS 13 Windows ODBC 42 ODBC/JDBC 16 [ODBC ]Windows 17 ORDER BYSQL 30 OR 40 OUTER JOIN 29 P POW 41 R Rapid Application DevelopmentRAD 21 REF 22 RIGHT 40 ROUND 41 RTRIM 40 S SELECTSQL 27 SELECT 28, 31 SELECT 28, 31 SPACE 41 SequeLink Server Host 18 SequeLink Server Port 18 SQL SQL 42 SQL 38 SQL 40 SQL 38 SQL 38 SQL 37 SQL 38 SQL 37 SQL 38 SQL 37 SQL 39 SQL 40 SQL 36 SQL_C_BINARY 27 SQL_C_WCHAR 27 SQL SQLExceptions 50 SQL ALTER TABLE 35 CREATE INDEX 36 CREATE TABLE 34 DELETE 33 DROP INDEX 36 INSERT 33 SELECT 27 UPDATE SQL 27 SSLSecure Sockets Layer 25 STRVAL 41 SUBSTR 40 Server Data Source 18

53 53 T TIME 41 TRIM 40 U Unicode 27 UNIONSQL 30 UPDATESQL 34 UPPER 40 USERNAME 41 V VALUESSQL 33 VAL 42 W Windows DSN 17 JDBC 13 JDBC 12 ODBC 18 ODBC 12 ODBC 11 Microsoft Access 17 WHERE SQL 29 X X 41 Y YEAR JDBC 25 ODBC Windows 18 JDBC 25 ODBC Windows FileMaker JDBC 13 FileMaker ODBC , INSERT 33 JDBC 47 SELECT 31 UPDATE QuickTime JDBC 21 ODBC 30 FileMaker ODBC JDBC DSNMac OS 19 SQL 43 ODBC/JDBC 16 FileMaker 8 38 FileMaker 7 27, SQL

54 54 FileMaker ODBC JDBC 21 8 FileMaker 7 JDBC 25 JDBC 23 ODBC Windows 18 ODBC Mac OS 19 ODBC Windows 17 FileMaker DSN 9 FileMaker 8 DSN JDBC 47 ODBC 45 8 Mac OS 19 Windows 18 19, 24 28, 29 SQL 36 FileMaker JDBC 13 FileMaker ODBC 12 8 JDBC 23 ODBC Mac OS 19 ODBC Windows 17 33, Mac OS 19 JDBC 47 ODBC JDBC 24 ODBC Mac OS 19 ODBC Windows JDBC 47 ODBC SQL JDBC 23 ODBC 18 27