FileMaker ODBC and JDBC Developer’s Guide

Size: px

Start display at page:

Download "FileMaker ODBC and JDBC Developer’s Guide"

うたろうくまじ
5 years ago
Views:

1 FileMaker 8 ODBC JDBC

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

3 1 7 7 FileMaker ODBC JDBC 7 FileMaker 7 8 FileMaker Pro 9 9 FileMaker 9 FileMaker Pro 9 2 ODBC FileMaker 11 ODBC 11 ODBC 12 FileMaker - 12 Windows FileMaker 13 ODBC Windows 13 FileMaker DSN ODBC Windows 13 ODBC Windows 14 Mac OS FileMaker 15 ODBC Mac OS 15 ODBC Mac OS 15 FileMaker DSN ODBC Mac OS 16 ODBC Mac OS 16 3 JDBC FileMaker 17 JDBC 17 JDBC 17 JDBC 17 JDBC 18 JDBC URL 18 URL 19 JDBC 20

4 4 FileMaker ODBC JDBC 4 21 Unicode 21 SQL 21 SELECT 21 DELETE 24 INSERT 24 UPDATE 25 CREATE TABLE 25 ALTER TABLE 26 CREATE INDEX 26 DROP INDEX 27 FROM 27 WHERE 27 GROUP BY 27 HAVING 28 UNION 28 ORDER BY 28 FOR UPDATE 29 SQL 29 SQL ODBC 35 JDBC 35 A FileMaker ODBC 37 B FileMaker Pro JDBC 39

5 5 C ODBC JDBC 41 ODBC 41 ODBC 41 ODBC 41 SequeLink Client 41 SequeLink Server JDBC 42 JDBC 42 SequeLink Server

6 6 FileMaker ODBC JDBC

7 1 FileMaker ODBC JDBC 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 1 FileMaker Pro 8FileMaker Pro 8 Advanced FileMaker Server 8 Advanced ODBC JDBC 1 ODBC JDBC SQL 1 ODBC FileMaker Pro FileMaker Pro 1 FileMaker Pro Web Web 1 FileMaker Pro Advanced FileMaker ProFileMaker Pro FileMaker Pro Advanced 1 FileMaker Server FileMaker Server 8 Advanced FileMaker Server 8 Advanced ODBC JDBC FileMaker FileMaker ODBC JDBC ODBC JDBC API API FileMaker Pro FileMaker Server ODBC JDBC SQL SQL FileMaker SQL ODBC JDBC FileMaker SELECT, FROM WHERE ='' INSERT INTO (, ) VALUES ('','') FileMaker FileMaker Server FileMaker ODBC JDBC FileMaker Server 50 Web

8 8 FileMaker ODBC JDBC FileMaker Pro FileMaker ODBC JDBC FileMaker Pro xdbc FileMaker Server FileMaker Pro FileMaker ODBC JDBC FileMaker CD xdbc FileMaker 8 FileMaker Server FileMaker FileMaker FileMaker [Get external data] [SQL query] ODBC JDBC FileMaker Pro FileMaker Server SQL 4 SQL ODBC/JDBC FileMaker Server FileMaker Pro ODBC JDBC FileMaker FileMaker Mac OS X 10.3 FileMaker ODBC/JDBC FileMaker Pro FileMaker Server Mac OS X 10.4 FileMaker FileMaker ODBC JDBC Microsoft Query 1 FileMaker ASCII Microsoft Query Microsoft Access 1 FileMaker ASCII 1 FileMaker FileMaker Server 8 FileMaker TCP/IP FileMaker Pro 8

9 1 9 FileMaker Pro FileMaker Pro ODBC Microsoft SQL Server 1 FileMaker decimalfloatmoney numeric [] Truncate(fieldname;0) FileMaker Pro 8 FileMaker FileMaker Server 8 FileMaker Pro 8 FileMaker Pro 7v3 FileMaker Server 8 FileMaker Pro FileMaker LDACLocal Data Access RDACRemote Data Access [ODBC/JDBC ] FileMaker Server FileMaker Pro ODBC/JDBC FileMaker Pro [] [] [ODBC/JDBC...] ODBC/JDBC FileMaker Pro Server Pro ODBC DSN DSN FileMaker FileMaker Server 7 FileMaker Pro 7 FileMaker DSN DSN FileMaker DSN FileMaker Pro Windows SQL Server Mac OS OpenLink iodbc FileMaker OpenLink iodbc FileMaker Pro Oracle SQL Server FileMaker Pro ODBC FileMaker Pro

10 10 FileMaker ODBC JDBC

11 2 ODBC FileMaker ODBC FileMaker ODBC FileMaker Windows FileMaker ODBC DataDirect 32-BIT SequeLink 5.4 Mac OS FileMaker ODBC ivslk18.dylib FileMaker Pro SQL ODBC ODBC FileMaker Pro ODBC ODBC API ODBC ODBC SQL SQL FileMaker ODBC SQL 4 ODBC FileMaker SQL FileMaker FileMaker Server FileMaker / ODBC Oracle ODBC SQL Server ODBC ODBC Oracle Microsoft SQL Server FileMaker

12 12 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 FileMaker Pro ODBC/JDBC FileMaker Pro FileMaker Server Pro ODBC ODBC FileMaker FileMaker - ODBC SQL FileMaker SQL ODBC FileMaker 1. FileMaker Pro [ODBC/JDBC ] 2. FileMaker ServerFileMaker Server Admin FileMaker Pro ODBC/JDBC FileMaker Server AdminWindows: [] [ ] [] [Server Advanced...] [ODBC JDBC ] FileMaker Server AdminMac OS: [] [] [ODBC JDBC ] FileMaker ProWindows: [] [] [ODBC/JDBC...] [ODBC/JDBC ] [] FileMaker ProMac OS: [FileMaker Pro] [] [ODBC/JDBC...] [ODBC/ JDBC ] [] 3. FileMaker FileMaker FileMaker 4. FileMaker

13 2 ODBC FileMaker 13 ODBC [Get external data] [SQL query] 5. SQL FileMaker FileMaker DSN FileMaker Windows Microsoft Access FileMaker ODBC Mac OS FileMaker ASCII FileMaker ASCII ODBC/JDBC DSN Windows FileMaker ODBC Windows ODBC FileMaker Server Web Publishing CD FileMaker Pro CD xdbc ODBC Client Driver Installer ODBC FileMaker ODBC FileMaker ODBC JDBC FileMaker Pro CD xdbc (PDF) FileMaker Server (PDF) PDF FileMaker DSN ODBC Windows FileMaker DSN Server Pro FileMaker DSN DSN FileMaker ODBC FileMaker Server FileMaker Pro FileMaker ODBC 1. [ODBC ] Windows [] [][ (ODBC)] Windows XP [] [] 2. [ DSN] DSN DSN 3. [...] [...] 6 4. [DataDirect 32-BIT SequeLink 5.4]

14 14 FileMaker ODBC JDBC ODBC Regedit HKEY_LOCAL_MACHINE SOFTWARE ODBC ODBCINST.INI ODBC Drivers () [] [] Regedit [()] [()] [] [ ] [()] ODBC ODBC ODBC 5. [] [ODBC DataDirect SequeLink Setup] [General] 6. [Data Source Name:] FileMaker [Description:] [Use LDAP] ODBC.DLL [Translate...] ODBC 7. [SequeLink Server Host:] FileMaker Pro FileMaker localhost FileMaker Server FileMaker FileMaker Server IP 8. [SequeLink Server Port:] [Server Data Source:] FileMaker FileMaker Pro FileMaker Server ODBC/JDBC [Server Data Source:] FileMaker %20 serverdatasource=my%20database 10. [OK] FileMaker [OK] [ODBC ] FileMaker [SequeLink Server Port:] 2399 ODBC Windows FileMaker ODBC 1. [ODBC ] Windows [] [][ (ODBC)] Windows XP [] [] 2. [ DSN] DSN DSN 3. FileMaker [] [] [DataDirect 32-BIT SequeLink 5.4]

15 2 ODBC FileMaker [...] [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 Mac OS FileMaker iodbc 3.51 ODBC Mac OS ODBC FileMaker Server Web Publishing CD FileMaker Pro CD xdbc ODBC Client Driver Installer PDF FileMaker ODBC JDBC ODBC SequeLink.bundle /ODBC SequeLink.bundle /Library/ODBC /Users/<>/Library/ODBC FileMaker Pro CD xdbc (PDF) FileMaker Server (PDF)FileMaker ODBC JDBC ODBC Mac OS iodbc ODBC Administrator OpenLink ODBC Administrator OpenLink Web ODBC-JDBC Lite Bridge ODBC Administrator 1 OpenLink ODBC Administrator OpenLink Software 1 Apple ODBC Administrator 1.0.1Mac OS X 10.3

16 16 FileMaker ODBC JDBC SequeLink.bundle /Library/ODBC /Users/<>/Library/ODBC /Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk18.dylib /Users/<>/Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk18.dylib ODBC Administrator FileMaker DSN ODBC Mac OS FileMaker DSN Server Pro FileMaker DSN DSN FileMaker ODBC FileMaker Mac OS ASCII FileMaker ASCII ODBC/JDBC DSN DSN Host Port ServerDataSource FileMaker Pro FileMaker localhost FileMaker Server FileMaker FileMaker Server IP 2399 FileMaker %20 ServerDataDource=MY%20DATABASE ODBC Administrator DSN Could not load the driver or translator setup library OpenLink Web ODBC-JDBC Lite Bridgem6I5jzzz.dmg ODBC Mac OS OpenLink ODBC Administrator FileMaker ODBC

17 3 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 / DBMS Java FileMaker JDBC JDBC Java Java RAD JDBC Java JDBC JDBC JDBC Java JDBC URL JDBC URL JDBC JDBC Java.jar JDBC Windows Mac OSFileMaker JDBC FileMaker ODBC JDBC FileMaker Pro CD xdbc (PDF) FileMaker Server (PDF) PDF

18 18 FileMaker ODBC JDBC JDBC JDBC JDBC SequeLink Developer s Reference JDBC JDKJava Development Kit1.4 FileMaker JDBC Java JDBC Java Java 2 JDBC 1.2 JDK 1.3 Java 2 com.ddtek.jdbc.sequelink.sequelinkdriver JDBC JDBC FileMaker JDBC URL Java URLUniform Resource LocatorJDBC URL JDBC JDBC URL jdbc:<subprotocol>:<subname> JDBC URL JDBC jdbcsubprotocol JDBC subprotocol sequelink subname FileMaker IP JDBC FileMaker JDBCTest 1. JDBC JDBC 2. FileMaker JDBC URL jdbc:sequelink:// : import java.sql.*; class FMPJDBCTest { public static void main(string[ ] args) { // JDBC try { Driver d = (Driver)Class.forName("com.ddtek.jdbc.sequelink.SequeLinkDriver").newInstance(); } catch(exception e) { System.out.println(e); } // FileMaker Connection con; try { con = DriverManager.getConnection("jdbc:sequelink:// :2399; user=some user;password=some password",username,password); } catch(exception e) { system.out.println(e);

19 3 JDBC FileMaker 19 } // SQLWarning warning = null; try { warning = con.getwarnings(); if (warning == null) { System.out.println(""); return; } while (warning!= null) { System.out.println(": "+warning); warning = warning.getnextwarning(); } } catch (Exception e) { Sysem.out.println(e); } } } URL user password JDBC URL Properties DriverManager.GetConnection 1 user: [ODBC/JDBC ] FileMaker 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

20 20 FileMaker ODBC JDBC URL JDBC URL : jdbc:sequelink://<sequelink IP >:< >;serverdatasource=<>;dbuser=<>; DBPassword=<> : jdbc:sequelink://<sequelink IP >:<>; serverdatasource=<>;huser=<>;hpassword=<> JDBC URL FileMaker SSLSecure Socket Layer JDBC Web https FileMaker.ASP.JSP JDBC JDBC JDBCTest JDBC [Install Developer s Tools] JDBCTest PDF FileMaker ODBC JDBC FileMaker JDBC JDBC FileMaker 1 FileMaker 1 FileMaker FileMaker [ODBC/JDBC ] 1 FileMaker Pro FileMaker Server ODBC/JDBC 1 JDBC JDBC URL Java Java JDBC FileMaker Web

21 4 FileMaker ODBC JDBC SQL ODBC JDBC FileMaker FileMaker FileMaker Pro FileMaker Server ODBC ODBC 3.5 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 INSERT UPDATE CREATE TABLE ALTER TABLE CREATE INDEX DROP INDEX FileMaker ODBC SQL JDBC SQL AFileMaker ODBC BFileMaker 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 {,...}] ] []

22 22 FileMaker ODBC JDBC SELECT * SELECT SELECT AS FROM.. DISTINCT SELECT DISTINCT FROM SQL FROM WHERE GROUP BY HAVING UNION ORDER BY FOR UPDATE SELECT FileMaker Pro FileMaker Pro 20,000,000 GROUP BY SELECT SELECT SELECT 2,000,000 SELECT, FROM WHERE >= ORDER BY SELECT,, FROM ORDER BY, 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

23 4 23 BLOB a * SQL SELECT FROM SELECT DISTINCT FROM SELECT FROM SELECT GETAS(, 'JPEG') FROM SELECT * FROM SELECT DISTINCT * FROM a. BLOB FileMaker SELECT FileMaker *SELECT * FROM SELECT DISTINCT * FROM SELECT * : CAST() GetAs() SELECT SELECT FROM JPEG SELECT SELECT <> SELECT CAST SELECT CAST( AS VARCHAR(NNN)) FROM 1 FileMaker Pro SELECT SQL_VARCHAR 1 FileMaker Pro SELECT 1 SELECT? FileMaker Pro Untitled.dat GetAs SELECT GetAs(, 'JPEG') FROM FileMaker 'BMPf' 'PCD ' Kodak PhotoCD 'EMBO' OLE 'PDF ' Portable Document Format 'EMF+' Windows 'PICT' Mac OS512-

24 24 FileMaker ODBC JDBC 'EPS ' Embedded PostScript 'PNGf' Bitmap 'FILE' [] 'PNTG' MacPaint 'FPix' FlashFPX 'qtif' QuickTime 'FORK' Mac OS '.SGI' 'GIFf' Graphics Interchange Format 'snd ' Mac OS raw 'JPEG' 'TIFF' 'JP2 ' JPEG 2000 'TPIC' Targa 'META' Windows 'XMLO' 'METO' Windows '8BPS' PhotoShop (PSD) 'moov' QuickTime Mac OS 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})

25 4 25 INSERT INSERT 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]

26 26 FileMaker ODBC JDBC 100 NOT NULL FileMaker [] FileMaker Pro [] [] [] 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 CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX [ ][ON]. CREATE INDEX FileMaker FileMaker [ ] [] FileMaker [ ] [] FileMaker [ ] [] CREATE INDEX ON.

27 4 27 DROP INDEX DROP INDEX DROP INDEX DROP INDEX [ON]. FileMaker SELECT FileMaker [ ] [] [] PREVENT INDEX CREATION DROP INDEX ON. 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

28 28 FileMaker ODBC JDBC SELECT SELECT, sum() FROM GROUP BY HAVING HAVING 20,000,000 GROUP BY 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 ORDER BY ORDER BY ORDER BY { [DESC ASC]},... ASC SELECT SELECT,, FROM ORDER BY, SELECT,, FROM ORDER BY 2,3 SELECT ORDER BY 2

29 4 29 FOR UPDATE FOR UPDATE SELECT FOR UPDATE [OF ] 2,000,000 SELECT * FROM WHERE > FOR UPDATE OF,, SQL SELECT AVG() AVG( * 1.07) DISTINCT COUNT (DISTINCT ) SQL 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.

30 30 FileMaker ODBC JDBC * :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' 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 +-*/ ^ ** +-

31 ' ' - - ' ' {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 =<>>>=< <=

32 32 FileMaker ODBC JDBC 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) AND OR = AND = 1 NOT NOT ( = AND = 1) SELECT * FROM WHERE. NOT LIKE '%' AND. > SELECT * FROM WHERE (. LIKE '%' OR. > ) AND. = 'SP-1' ODBC JDBC SQL

33 4 33 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',3) Mat RIGHT RIGHT('Mattson',4) tson SUBSTR 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({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

34 34 FileMaker ODBC JDBC 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) 123 ROUND( ,2) ROUND( , -2) 100 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 */ =<><<=>>=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 > {1989/01/30}) AND = 'D101' 4,000, D101

35 4 35 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 JDBC Java dmd.getfunction

36 36 FileMaker ODBC JDBC

37 A FileMaker ODBC FileMaker Pro ODBC FileMaker ODBC SQL_VARCHAR FileMaker [:] 100 FileMaker 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

38 38 FileMaker ODBC JDBC

39 B FileMaker Pro JDBC JDBC FileMaker JDBC SQL JDK 1.4 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

40 40 FileMaker ODBC JDBC

41 C 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] [DataDirect] [ODBC SequeLink driver] [SequeLink Server] Only SELECT statements are allowed in this read-only connection.

42 42 FileMaker ODBC JDBC [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

43 A ALTER TABLESQL 26 C CAST 23, 37 CREATE INDEXSQL 26 CREATE TABLESQL 25 D Data Source Name 14 DELETESQL 24 DROP INDEXSQL 27 F FileMaker 7 FileMaker JDBC 19 ODBC Mac OS 16 ODBC Windows 13 FileMaker 7 FOR UPDATESQL 29 FROMSQL 27 G GetAs 23, 37 GROUP BYSQL 27 H HAVINGSQL 28 I INNER JOIN 27 INSERTSQL 24 J JDBC JDBC URL 18 JDBC 18 Unicode JDBC URLUniform Resource Locator 18 JDBC 18 JDBC 35 JDBC 17 Java Development KitJDK 18 L Local Data Access LDAC 9 M Microsoft Access 8 Microsoft Query 8 Microsoft SQL Server 9 O ODBC ODBC FileMaker 37 Unicode 21 Mac OS 16 Windows 14 Mac OS 15 Windows ODBC 35 ORDER BYSQL 28 OUTER JOIN 27 R Remote Data Access RDAC 9 Rapid Application DevelopmentRAD 17 S SELECTSQL 21 SQL SQL 34

44 44 FileMaker ODBC JDBC SQL 30 SQL 32 SQL 30 SQL 30 SQL 30 SQL 31 SQL 29 SQL 31 SQL 30 SQL 31 SQL 32 SQL ALTER TABLE 26 CREATE INDEX 26 CREATE TABLE 25 DELETE 24 DROP INDEX 27 INSERT 24 SELECT 21 UPDATE SQL 29 SQL SSLSecure Sockets Layer 20 SequeLink Server Host 14 SequeLink Server Port 14 Server Data Source 14 U UNIONSQL 28 UPDATESQL 25 Unicode 21 W WHERE SQL 27 JDBC 20 ODBC Mac OS 16 ODBC Windows 14 JDBC 20 ODBC Mac OS 16 ODBC Windows 14 16, 19 FileMaker 8 FileMaker 9 21, SQL 29 FileMaker 7 JDBC 20 JDBC 19 ODBC Mac OS 16 ODBC Windows 14 ODBC Mac OS 16 ODBC Windows 13 FileMaker DSN 9 FileMaker 8 JDBC 39 ODBC 37 16, 19 SQL 29 JDBC 19 ODBC Mac OS 16 ODBC Windows 13 8 JDBC 39 ODBC

FileMaker 15 ODBC と JDBC ガイド

FileMaker 15 ODBC と JDBC ガイド FileMaker 15 ODBC JDBC 2004-2016 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker,