FileMaker ODBC and JDBC Guide
|
|
- そよ ありの
- 5 years ago
- Views:
Transcription
1 FileMaker 9 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 7 FileMaker Pro FileMaker ODBC JDBC ODBC Windows 11 ODBC Mac OS 11 JDBC ODBC Windows 12 ODBC Mac OS 12 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
4 4 FileMaker ODBC JDBC JDBC 21 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 A FileMaker ODBC 45 B FileMaker Pro JDBC 47 C 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 FileMaker Pro / FileMaker Pro 1. SQL 2. JDBC FileMaker Pro 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 5.5 LDACLocal Data Access RDACRemote Data Access [ODBC/JDBC ] ODBC/JDBC FileMaker Pro
9 1 9 FileMaker Server 9 Advanced FileMaker Pro 9 2 FileMaker ODBC JDBC 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 JDBC 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 [] [] [ ] [] ODBC Mac OS Mac OS ODBC
13 2 FileMaker ODBC JDBC 13 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 Administrator 1.0.1Mac OS 10.4 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] 1 Windows: java java.exe 1 Mac OS: /Library/Java/Extensions java ClassPath 6. [Next] 7. [Install] 8. [Finish] FileMaker JDBC
14 14 FileMaker ODBC 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 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 Microsoft Access FileMaker ODBC
17 3 ODBC FileMaker 17 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:] FileMaker Pro FileMaker localhost FileMaker Server FileMaker FileMaker Server IP 8. [SequeLink Server Port:] 2399 FileMaker [SequeLink Server Port:] [Server Data Source:] FileMaker 10. ODBC/JDBC [Server Data Source] FileMaker
18 18 FileMaker ODBC JDBC %20 serverdatasource=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.1Mac OS 10.4 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 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) FileMaker JDBC Java JDBC Java Java 2 JDBC 1.2 JDK 1.3 Java 2 com.ddtek.jdbc.sequelink.sequelinkdriver FileMaker 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
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 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 {,...}] ] []
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 <> 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 : SELECT GetAs(, 'JPEG') FROM FileMaker 'EMBO' OLE 'PDF ' Portable Document Format 'EMF+' Windows Enhanced Metafile Plus 'PICT' Mac OS512- '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
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 A 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 B 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 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]
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 ALL 39 ALTER TABLESQL 35 AND 40 ANY 39 API 7 ARRAY 22 AccessMicrosoftMicrosoft Access 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 7 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 Local Data Access LDAC 8 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 19 ODBC 12 ODBC 11 MAX 41 MIN 41 MOD 41 MONTH 41 Microsoft Access 8 16 Microsoft Query 8 N NOT NULLSQL 34 NOT 40 NUMVAL 42 O ODBC ODBC AdministratorMac OS 19 ODBC FileMaker 45 Unicode 27 Windows 18 Mac OS 12 Windows ODBC 42 ODBC/JDBC 16 [ODBC ]Windows 17 ORDER BYSQL 30 OR 40 OUTER JOIN 29 P POW 41 R Remote Data Access RDAC 8 REF 22 RIGHT 40 ROUND 41 RTRIM 40 Rapid Application DevelopmentRAD 21 S SELECTSQL 27 SELECT 28, 31 SELECT 28, 31 SPACE 41 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 SQLExceptions 50 SQL_C_BINARY 27 SQL_C_WCHAR 27 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 SequeLink Server Host 17 SequeLink Server Port 17 Server Data Source 17
53 53 T TIME 41 TRIM 40 U UNIONSQL 30 UPDATESQL 34 UPPER 40 USERNAME 41 Unicode 27 V VALUESSQL 33 VAL 42 W WHERE SQL 29 Windows DSN 17 JDBC 13 JDBC 12 ODBC 18 ODBC 12 ODBC 11 Microsoft Access 16 X X 41 Y YEAR 41 JDBC 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 FileMaker ODBC JDBC 7 16 DSNMac OS 19 SQL 43 ODBC/JDBC 16 FileMaker 8 38 FileMaker 7 27,
54 54 FileMaker ODBC JDBC 33 SQL , 29 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 SQL 36 FileMaker JDBC 13 FileMaker ODBC 12 9 JDBC 23 ODBC Mac OS 19 ODBC Windows 17 33, 45 8 JDBC 23 ODBC Mac OS 19 JDBC 47 ODBC JDBC 24 ODBC Mac OS 19 ODBC Windows 17 JDBC 47 ODBC SQL
FileMaker ODBC and JDBC Developer’s Guide
FileMaker 8 ODBC JDBC 2004-2005 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker
More informationFileMaker ODBC and JDBC Guide
FileMaker 13 ODBC JDBC 2004-2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker,
More informationFileMaker 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,
More informationFileMaker ODBC and JDBC Guide
FileMaker 14 ODBC JDBC 2004-2015 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker,
More informationFileMaker 16 ODBC と JDBC ガイド
FileMaker 16 ODBC JDBC 2004-2017 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker
More informationFileMaker ODBC and JDBC Guide
FileMaker 10 ODBC JDBC 2007-2009 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento Bento FileMaker, Inc. Mac Mac Apple Inc. FileMaker
More informationFileMaker ODBC と JDBC ガイド
FileMaker ODBC JDBC 2004-2019 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker CloudFileMaker Go FileMaker, Inc. FileMaker
More informationFileMaker SQL Reference
FileMaker 13 SQL 2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker, Inc.
More informationFileMaker ODBC and JDBC Guide
FileMaker 11 ODBC JDBC 2004-2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker, Inc. FileMaker, Inc. FileMaker FileMaker,
More informationデータベース移行ツール操作説明書 日本ブレイディ株式会社
データベース移行ツール操作説明書 日本ブレイディ株式会社 本書に記載されている情報は契約の対象とはなりません 本書の内容は事前の予告なく変 更される可能性があります 本書に記載されているソフトウェアの使用には ユーザーライセンス契約の条項が適用され ます 本ソフトウェアは このライセンス契約の条項に準拠する場合を除き それを無断で使 用することは禁止されており いかなる媒体への複写および複製もできません
More informationFileMaker 15 SQL リファレンスガイド
FileMaker 15 SQL 2013-2016 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker,
More information橡j_Oracle_whitepaper.PDF
Pervasive-Oracle 1 1 Pervasive Software Pervasive-Oracle / Pervasive Oracle Pervasive-Oracle ISV Pervasive-Oracle Pervasive.SQL Oracle 2 Pervasive-Oracle Pervasive-Oracle Pervasive.SQL Oracle Open Database
More informationFileMaker ODBC and JDBC Guide
FileMaker 12 ODBC JDBC 2004 2012 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. Bento FileMaker, Inc. FileMaker
More information1,.,,,., RDBM, SQL. OSS,, SQL,,.
1,.,,,., RDBM, SQL. OSS,, SQL,,. 3 10 10 OSS RDBMS SQL 11 10.1 OSS RDBMS............................ 11 10.1.1 PostgreSQL................................. 11 10.1.2 MySQL...................................
More informationFileMaker Server Getting Started Guide
FileMaker Server 11 2004-2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. FileMaker, Inc. FileMaker FileMaker,
More informationFileMaker Server Getting Started Guide
FileMaker Server 12 2007 2012 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. Bento FileMaker, Inc. FileMaker
More informationFileMaker Server 9 Getting Started Guide
FileMaker Server 10 2007-2009 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento Bento FileMaker, Inc. Mac Mac Apple Inc. FileMaker
More informationFileMaker Server 9 Getting Started Guide
FileMaker Server 9 2007 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker FileMaker,
More information1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058
1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058 2 Excel 1 SQL 1 SQL Server sp_executesql Oracle SQL
More informationODBC Driver for 4D Server
by ACI Copyright 1993 1997 ACI SA/ACI US, Inc. All rights reserved Ô ÔÕ SQL_DATE SQL_TIMESTAMP SQL_CHAR SQL_VARCHAR SQL_LONGVARCHAR SELECT CLIENTS.ID CLIENTS.String 1 MyString 2
More informationInstallation and New Features Guide for FileMaker Pro and FileMaker Pro Advanced
FileMaker For FileMaker Pro 8.5 and FileMaker Pro 8.5 Advanced 2005-2006 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker,
More informationInstallation and New Features Guide for FileMaker Pro 10 and FileMaker Pro 10 Advanced
FileMaker FileMaker Pro 10 and FileMaker Pro 10 Advanced 2007-2009 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento Bento FileMaker,
More informationUsing a Remote Desktop Connection with FileMaker Pro
FileMaker Pro 12 FileMaker Pro 12 2007 2012 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. Bento FileMaker,
More informationFileMaker Server Getting Started Guide
FileMaker Server 13 2007-2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker,
More informationFileMaker Server 8 Administrator’s Guide
1994-2005 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker
More information,, create table drop table alter table
PostgreSQL 1 1 2 1 3,, 2 3.1 - create table........................... 2 3.2 - drop table............................ 3 3.3 - alter table............................ 4 4 - copy 5 4.1..................................
More informationFileMaker, Inc. All Rights Reserved. FileMaker, Inc Patrick Henry Drive Santa Clara, California FileMaker FileMaker, Inc. FileMa
FileMaker Pro 11 FileMaker Pro 11 2007 2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. FileMaker, Inc. FileMaker
More informationRunning FileMaker Pro 8 on Windows Server 2003 Terminal Services
FileMaker FileMaker Pro 10 2007-2009 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento Bento FileMaker, Inc. Mac Mac Apple Inc.
More informationRunning FileMaker Pro 8 on Citrix Presentation Server
FileMaker Citrix Presentation Server FileMaker Pro 10 2007-2009 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento Bento FileMaker,
More informationInstallation and New Features Guide for FileMaker Pro and FileMaker Pro Advanced
FileMaker FileMaker Pro 11 and FileMaker Pro 11 Advanced 2007-2010 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker,
More information1 ex01.sql ex01.sql ; user_id from (select user_id ;) user_id * select select (3+4)*7, SIN(PI()/2) ; (1) select < > from < > ; :, * user_id user_name
SQL mysql mysql ( mush, potato) % mysql -u mush -p mydb Enter password:****** mysql>show tables; usertable mysql> ( ) SQL (Query) : select < > from < > where < >; : create, drop, insert, delete,... ; (
More informationUsing a Remote Desktop Connection with FileMaker Pro
FileMaker Pro 13 FileMaker Pro 13 2007-2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. WebDirect Bento FileMaker,
More informationtkk0408nari
SQLStatement Class Sql Database SQL Structured Query Language( ) ISO JIS http://www.techscore.com/tech/sql/02_02.html Database sql Perl Java SQL ( ) create table tu_data ( id integer not null, -- id aid
More informationFileMaker Pro Tutorial
FileMaker Pro 11 2007-2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. FileMaker, Inc. FileMaker FileMaker, Inc.
More informationFileMaker Pro 11 Citrix XenApp FileMaker Pro 11
FileMaker Pro 11 Citrix XenApp FileMaker Pro 11 2007 2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. FileMaker,
More informationFileMaker Pro Tutorial
FileMaker Pro 12 2007-2012 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. Bento FileMaker, Inc. FileMaker FileMaker,
More informationストラドプロシージャの呼び出し方
Release10.5 Oracle DataServer Informix MS SQL NXJ SQL JDBC Java JDBC NXJ : NXJ JDBC / NXJ EXEC SQL [USING CONNECTION ] CALL [.][.] ([])
More informationFileMaker Server 16 インストールおよび構成ガイド
FileMaker Server 16 2007-2017 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker
More informationActual ESS Adapterの使用について
Actual ESS Adapter SQL External SQL Source FileMaker SQL ESS SQL FileMaker FileMaker SQL FileMaker FileMaker ESS SQL SQL FileMaker ODBC SQL FileMaker Microsoft SQL Server MySQL Oracle 3 ODBC Mac OS X Actual
More informationRunning FileMaker Pro 8 on Citrix Presentation Server
FileMaker Citrix Presentation Server FileMaker Pro 8 2001-2005 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. ScriptMaker
More informationFileMaker Server 15 入門ガイド
FileMaker Server 15 2007-2016 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker,
More informationTopLink å SampleClient.java... 5 Ò readallsample() querysample() cachesample() Ç..
lê~åäé= qçéiáåâ= NMÖENMKNKPF Volume2 Creation Date: Mar 04, 2005 Last Update: Aug 22, 2005 Version 1.0 ...3... 3 TopLink å...4 1... 4... 4 SampleClient.java... 5 Ò... 8... 9... 10 readallsample()... 11
More informationFileMaker Pro Advanced Development Guide
FileMaker Pro 11 Advanced 2007 2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker, Inc. FileMaker, Inc. FileMaker FileMaker,
More information意外と簡単!?
!?Access Oracle Oracle Migration Workbench MS-Access Oracle Creation Date: Oct 01, 2004 Last Update: Mar 08, 2005 Version: 1.1 !? Oracle Database 10g / GUI!? / Standard Edition!? /!?!? Oracle Database
More informationFileMaker Pro 8.5 Tutorial
2004 2006 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker
More information日本オラクル株式会社
FISC 6 Oracle Database 10g ~ ~ : 2005 7 26 : 2005 7 31 : 1.0 2004 4 (* ) FISC ) (* ) FISC 6 (* FISC 6 ) FISC 6 Oracle g Database 10 (FISC) http://www.fisc.or.jp FISC http://www.fisc.or.jp/info/info/050307-1.htm
More informationFileMaker Server 8 Advanced Web Publishing Installation Guide
FileMaker Server 8 Advanced! 13 2004-2005 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. ScriptMaker FileMaker, Inc.
More informationFileMaker Pro 9 Advanced Development Guide
FileMaker Pro 10 Advanced 2007-2009 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento Bento FileMaker, Inc. Mac Mac Apple Inc.
More informationUsing a Remote Desktop Connection with FileMaker Pro
FileMaker Pro 14 FileMaker Pro 14 2007 2015 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker
More informationSQL (2) データベース論 Ⅰ 第 7 回 URL 作成者末次文雄 C
SQL (2) データベース論 Ⅰ 第 7 回 URL http://homepage3.nifty.com/suetsuguf/ 作成者末次文雄 C 課題 6 の解答例 テーブル定義 CREATE DATABASE 学科 ; CREATE TABLE 学科 TBL ( 学科番号 INT(7) NOT NULL UNIQUE, 学科名称 NCHAR(10), 主任 NCHAR(10) ); CREATE
More informationFileMaker Pro 9 Tutorial
FileMaker Pro 10 2007-2009 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento Bento FileMaker, Inc. Mac Mac Apple Inc. FileMaker
More informationFileMaker Pro 9 Advanced Development Guide
FileMaker Pro 9 Advanced 2007 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker
More information橡実践Oracle Objects for OLE
THE Database FOR Network Computing 2 1. 2 1-1. PL/SQL 2 1-2. 9 1-3. PL/SQL 11 2. 14 3. 16 3-1. NUMBER 16 3-2. CHAR/VARCHAR2 18 3-3. DATE 18 4. 23 4-1. 23 4-2. / 24 26 1. COPYTOCLIPBOARD 26 III. 28 1.
More informationFileMaker Server Getting Started Guide
FileMaker Server 14 2007-2015 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker,
More informationInstallation and New Features Guide for FileMaker Pro and FileMaker Pro Advanced
FileMaker FileMaker Pro 12 FileMaker Pro 12 Advanced 2007-2012 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc.
More informationFileMaker Mobile 8 User’s Guide
For Windows, Mac, Palm OS, and Pocket PC FileMaker Mobile 8 Companion for Palm OS and Pocket PC 2000-2006 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California
More informationFileMaker Instant Web Publishing Guide
FileMaker 8 Web 2004-2005 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker FileMaker,
More informationMicrosoft Word - 430_15_Developing_Stored_Procedure.doc
Java Oracle 1998 11 Java 3 Java Web GUI Java Java Java Oracle Java Oracle8i Oracle / Oracle Java Virtual Machine VM CORBA Enterprise JavaBeans Oracle Java Java Java Oracle Oracle Java Virtual Machine Oracle
More informationMicrosoft PowerPoint - db03-5.ppt
データベース言語 SQL リレーショナルデータモデルにおけるデータ操作言語 : リレーショナル代数 少なくともリレーショナル代数と同等のデータ検索能力をもつときリレーショナル完備という. リレーショナル代数はユーザフレンドリではない. 自然な英文による質問の表現が必要になる. リレーショナルデータベース言語 SQL 英文による簡単な構文 リレーショナル代数でできない, 合計, 平均, 最大などの計算機能の組み込み.
More information外部SQLソース入門
Introduction to External SQL Sources 外部 SQL ソース入門 3 ESS 3 ESS : 4 ESS : 4 5 ESS 5 Step 1:... 6 Step 2: DSN... 6 Step 3: FileMaker Pro... 6 Step 4: FileMaker Pro 1. 6 Step 5:... 6 Step 6: FileMaker Pro...
More informationii II Web Web HTML CSS PHP MySQL Web Web CSS JavaScript Web SQL Web 2014 3
Web 2.0 Web Web Web Web Web Web Web I II I ii II Web Web HTML CSS PHP MySQL Web Web CSS JavaScript Web SQL Web 2014 3 1. 1.1 Web... 1 1.1.1... 3 1.1.2... 3 1.1.3... 4 1.2... 4 I 2 5 2. HTMLCSS 2.1 HTML...
More informationuntitled
cibm() Information Management DB2 UDB V8.2 SQL cibm() Information Management 2 DB2 UDB V8.2 SQL cibm() Information Management 3 DB2 UDB V8.2 SQL cibm() Information Management 4 cibm() Information Management
More informationPowerPoint -O80_REP.PDF
Oracle8 Core Technology Seminar 1997109,31 Oracle8 OS: UNIX Oracle8 : Release8.0.3 Oracle8 Quick Start Package Lesson 5 -- Enhancements to Distributed Facilities Oracle8 -- - Oracle8 LOB Oracle8 -- - Updates
More informationOracle Rdb: SQL Update
Day1-7 SQL Oracle Rdb 2006 4 3 2006 4 5 2005-2006, Oracle Corporation RMU Extract SQL DDL SQL 2 7.1 7.1.3 SQL V7.1.4.1 SQL 4 7.2 Rdb RMU Oracle Rdb Rdb Installation and Configuration Guide SQL/Services
More informationFileMaker Instant Web Publishing Guide
FileMaker 11 Web 2004-2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. Bento FileMaker, Inc. FileMaker FileMaker,
More informationOracle Web Conferencing Oracle Collaboration Suite 2 (9.0.4) Creation Date: May 14, 2003 Last Update: Jan 21, 2005 Version: 1.21
Oracle Web Conferencing Oracle Collaboration Suite 2 (9.0.4) Creation Date: May 14, 2003 Last Update: Jan 21, 2005 Version: 1.21 ... 2... 3...3...4...5 Oracle9i Platform...10 Oracle Collaboration Suite...12...15...23
More information~~~~~~~~~~~~~~~~~~ wait Call CPU time 1, latch: library cache 7, latch: library cache lock 4, job scheduler co
072 DB Magazine 2007 September ~~~~~~~~~~~~~~~~~~ wait Call CPU time 1,055 34.7 latch: library cache 7,278 750 103 24.7 latch: library cache lock 4,194 465 111 15.3 job scheduler coordinator slave wait
More informationFileMaker Server Help
FileMaker Server 13 FileMaker Server 2010-2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. FileMaker WebDirect
More informationBento 3
Bento 3 2007-2009 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento Bento FileMaker,Inc. Mac Mac Apple Inc. FileMaker FileMaker,
More informationデータベース認識Webサービス
Olivier Le Diouris, Oracle Corporation PL/SQL PL/SQL SOAP SOAP SOAP Web Java Java SOAP Perl Perl PL/SQL SOAP PL/SQL 1. URL 2. SOAP 1. 2. 3. 1 JSR 109 J2EE JSR 109 J2EE J2EE PL/SQL Java 2 3 JPublisher PL/SQL
More informationOracle Lite Tutorial
GrapeCity -.NET with GrapeCity - FlexGrid Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0 Document Control Internal Use Only Author Hiroshi Ota Change Logs Date Author Version Change
More informationFileMaker Instant Web Publishing Guide
FileMaker 8.5 Web 2004-2006 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker FileMaker,
More information2 Java 35 Java Java HTML/CSS/JavaScript Java Java JSP MySQL Java 9:00 17:30 12:00 13: 項目 日数 時間 習得目標スキル Java 2 15 Web Java Java J
1 2018 4 Java 35 35 262.5 30 1 1 1,045,300 653,300 656,000 2017 12 389,300 2,700 2 946,900 554,900 290,900 101,100 1 2 Java Java Java Web Eclipse Java List Set Map StringBuilder HTML/CSS/JavaScript JSP/Servlet
More informationFileMaker Server Help
FileMaker Server 11 FileMaker Server 2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. FileMaker, Inc. FileMaker
More informationInstallation and New Features Guide for FileMaker Pro and FileMaker Pro Advanced
FileMaker FileMaker Pro 14 FileMaker Pro 14 Advanced 2007-2015 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker,
More informationeラーニング資料 e ラーニングの制作目標 データベース編 41 ページデータベースの基本となる概要を以下に示す この内容のコースで eラーニングコンテンツを作成予定 データベース管理 コンピュータで行われる基本的なデータに対する処理は 次の 4 種類です 新しいデータを追加する 既存のデータを探索
eラーニング資料 e ラーニングの制作目標 データベース編 41 ページデータベースの基本となる概要を以下に示す この内容のコースで eラーニングコンテンツを作成予定 データベース管理 コンピュータで行われる基本的なデータに対する処理は 次の 4 種類です 新しいデータを追加する 既存のデータを探索する 違うデータに変更する 要らなくなったデータを削除する 各システムごとに障害対策も含めて 正確にこのようなデータ処理のプログラムを作ることは大変なことです
More informationJava演習(4) -- 変数と型 --
50 20 20 5 (20, 20) O 50 100 150 200 250 300 350 x (reserved 50 100 y 50 20 20 5 (20, 20) (1)(Blocks1.java) import javax.swing.japplet; import java.awt.graphics; (reserved public class Blocks1 extends
More informationはじめに 本書では GridDB Advanced Edition における SQL の記述方法および 注意事項について記載しています GridDB Advanced Edition をご使用になる前に 必ずお読みください なお 本書で説明する機能は GridDB Advanced Edition
GMA022D0 GridDB Advanced Edition SQL リファレンス Toshiba Solutions Corporation 2016 All Rights Reserved. はじめに 本書では GridDB Advanced Edition における SQL の記述方法および 注意事項について記載しています GridDB Advanced Edition をご使用になる前に
More informationFileMaker Pro 15 および FileMaker Pro 15 Advanced インストールおよび新機能ガイド
FileMaker FileMaker Pro 15 FileMaker Pro 15 Advanced 2007-2016 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker,
More information橡PervasiveSQL2000ReviewersGuide.PDF
Pervasive.SQL 2000 Reviewer s Guide Pervasive.SQL TM 2000 Reviewer s Guide Rev.1 11/99 Pervasive Software Inc. The Freedom to Create Applications for Everyone, Everywhere ...3 Pervasive.SQL 2000...4 Pervasive.SQL
More informationKeySQL for Microsoft Windows 6.0 : B28350-01 Copyright 2006, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Co
KeySQL for Microsoft Windows 6.0 2006 3 : B28350-01 Copyright 2006, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation KeySQL for Microsoft Windows 6.0 : B28350-01 Copyright 2006, Oracle
More informationKeySQL R5.1 Release Note
KeySQL for Microsoft Windows 5.1 2005 10 : B19176-02 Copyright 2005, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation KeySQL for Microsoft Windows 5.1 : B19176-02 Copyright 2005,
More information3 Powered by mod_perl, Apache & MySQL use Item; my $item = Item->new( id => 1, name => ' ', price => 1200,
WEB DB PRESS Vol.1 79 3 Powered by mod_perl, Apache & MySQL use Item; my $item = Item->new( id => 1, name => ' ', price => 1200, http://www.postgresql.org/http://www.jp.postgresql.org/ 80 WEB DB PRESS
More informationFileMaker Instant Web Publishing Guide
FileMaker 9 Web 2004-2007 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMakerFileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker FileMaker,
More informationOracle Application Server 10g Release 3(10.1.3)- アジャイル・エンタープライズ(俊敏な企業)のためのデータ・アクセス
Oracle Application Server 10g Release 3 10.1.3 2005 8 Oracle Application Server 10g Release 3 10.1.3... 3 Oracle Application Server 10g Release 3 10.1.3 3... 4... 4 RAC... 6 JDBC... 7 JMX... 8... 9 Oracle...
More informationFileMaker WebDirect Guide
FileMaker 13 WebDirect 2014 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker,
More informationConfiguring_01
Symantec Backup Exec Dell EqualLogic Microsoft Exchange Server SQL Server IT / / 24 365 Symantec Backup Exec Advanced Disk-based Backup Option (ADBO) Dell Equal- Logic Microsoft Exchange Server 2003 2007
More informationOracle Lite Tutorial
GrapeCity -.NET with GrapeCity - SPREAD Creation Date: Nov. 30, 2005 Last Update: Nov. 30, 2005 Version: 1.0 Document Control Internal Use Only Author Hiroshi Ota Change Logs Date Author Version Change
More information<Documents Title Here>
Oracle Application Server 10g Release 2 (10.1.2) for Microsoft Windows Business Intelligence Standalone Oracle Application Server 10g Release 2 (10.1.2) for Microsoft Windows Business Intelligence Standalone
More informationJEE 上の Adobe Experience Manager forms のインストールおよびデプロイ(WebLogic 版)
JEE ADOBE EXPERIENCE MANAGER FORMS WEBLOGIC http://help.adobe.com/ja_jp/legalnotices/index.html iii 1 AEM forms 2 AEM Forms 3 4 - WebLogic Server 4.1............................................................................
More informationuntitled
Oracle Direct Seminar SQL Agenda SQL SQL SQL SQL 11g SQL FAQ Oracle Direct SQL Server MySQL PostgreSQL Access Application Server Oracle Database Oracle Developer/2000 Web Oracle Database
More informationBento User’s Guide
Bento 4 2007-2012 FileMaker, Inc. All rights reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. Bento FileMaker, Inc. FileMaker FileMaker,
More informationFaronics Core User Guide
1 2 : 2017 2 1999-2017 Faronics Corporation. All rights reserved. Faronics Deep Freeze Faronics Core Console Faronics Anti-Executable Faronics Device Filter Faronics Power Save Faronics Insight Faronics
More informationuntitled
Oracle Database Lite 10 g GUI Win32 Agenda Win32 Oracle Database Lite 10g Mobile Database WorkbenchGUI Oracle Database Lite 10g 10.2.0 21 Win32 Mobile Database Workbench Oracle Database Lite10g Release2
More informationEPSON Offirio SynergyWare PrintDirector 取扱説明書 導入ガイド
Offirio SynergyWare PrintDirector K L Microsoft WindowsNT Operating System Version4.0 Microsoft Windows 2000 Operating System Microsoft Windows Server 2003, Standard Edition Microsoft Windows Server 2003,
More informationn n n ( ) n Oracle 16 PostgreSQL 3 MySQL
SaaS CAM MACS PostgreSQL ~ ~ 7 PostgreSQL in 2014/02/07 n n n ( ) n Oracle 16 PostgreSQL 3 MySQL n SaaS CAM MACS n AWS n 1993 6 1 1999 4 1 C/S CAM MACS 2007 4 1 SaaS CAM MACS 2007 11 1 SaaS CAM MACS CAM
More informationFileMaker Help-M2 Template Guide
FileMaker Server 9 2001-2007 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker, Inc. ScriptMaker FileMaker, Inc. FileMaker
More informationFileMaker 15 WebDirect ガイド
FileMaker 15 WebDirect 2013 2016 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker,
More informationuntitled
Worldspan go! 4.x (UCI) Administrator Guide go! 4.x (UCI) Version 2.1.4 : 31 August 2007 1. WORLDSPAN GO! VERSION 4.X (UCI)... 3 2. WORLDSPAN GO! VERSION 4.X (UCI)... 4 3.... 6 4. WORLDSPAN GO! VERSION
More informationKWCR3.0 instration
KeyWeb Creator R3.0 R3.0 for MS-Windows 2005 10 B25586-01 Oracle Oracle Oracle Corporation Copyright 2005, Oracle Corporation All Right Reserved KeyWeb Creator R3.0 2005 10 Copyright 1997-2005 KeyWeb Creator
More information