KeySQL R5.1 Release Note

Size: px

Start display at page:

Download "KeySQL R5.1 Release Note"

よしじろういなくら
9 years ago
Views:

2 KeySQL for Microsoft Windows 5.1 : B Copyright 2005, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Corporation Restricted Rights Notice Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercialcomputer software" and use,duplication, and disclosure of the Programs,including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR , Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA KeySQL for Microsoft Windows 5.1

and disclosure of the Programs,including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement.

3 KeySQL R5. 1 KeySQL OTN-J Oracle Technology Network Japan OTN-J KeySQL URL 3

4 Excel KeySQL KeySQL R R4.2 R X R4.X X KeySQL R4.2 R5.0 R NCHAR / NVARCHAR2 / Excel / Error 19 Error KeySQL for Microsoft Windows 5.1

1... 14... 15... 18... 19... 19 NCHAR / NVARCHAR2 /... 19 Excel /.

5 Microsoft Windows 98 Second Edition Windows NT4.0 SP5 Windows 2000 Windows XP Professional (32-bit) Windows Server 2003(32-bit) Oracle Net R8.1.7 Oracle Oracle Client (Oracle Net Services) OS OS Microsoft Internet Explorer Version5.5 64M 128M KeySQL 20MB CD-ROM KeySQL CD-ROM 5

6 Windows Administrator KeySQL R5.1 KeySQL CD CD-ROM CD-ROM Setup.exe 1. KeySQL R5.1 MAC VBA KeySQL 2. KeySQL 3. KeySQL R KeySQL R MAC Excel KeySQL Excel Excel KeySQL KeySQL KeySQL KeySQL PATH KeySQL 6 KeySQL for Microsoft Windows 5.1

1 MAC VBA KeySQL 2. KeySQL 3. KeySQL R5.1 4. KeySQL R5.1 1.

7 KeySQL R5.0 Excel KeySQL Excel KeySQL VBA Viewlet KeySQL SQL Oracle 10g NCHAR NVARCHAR ( 1) ( 1 Oracle8i ) KeySQL MAC V3.X KeySQL R5.0 7

8 Excel VBA V3.X 8 KeySQL for Microsoft Windows 5.1

9 R4.2 R5.0 Excel2003 Excel2003 TIMESTAMP TIMESTAMP INTERVAL INTERVAL Excel KeySQL Excel Excel KeySQL Excel KeySQL MAC V3.X Excel VBA V3.X 3.X R4.X Excel2000 Excel2000 9

10 TNSNAME Windows2000 Windows Windows Administrator KeySQL R4.2 7 Terminal Service MS Windows Terminal Service HTML HTML CSV CSV 10 KeySQL for Microsoft Windows 5.1

11 SQL KeySQL SQL / Excel 97 SQL " - - " "," " Having "(EMP.SAL+EMP.SAL)* 2 > 0" () 11

12 KeySQL 4000 KeySQL Ctrl-C KeySQL VBA V3.X KeySQL X Excel Excel Excel Excel VBA V2.5 Excel 5.0 Excel VBA KeySQL DDE "SYSTEM" V2.5 Cn = DDEInitiate("KEYSQL","EXECUTE") V3.X Cn = DDEInitiate("KEYSQL","SYSTEM") KeySQL DDE [ ] V2.5 Cn = DDEExecute(Cn,"Fetch()") V3.X Cn = DDEExecute(Cn,"[Fetch()]") SQL "ExecSQL" "KeyExecSQL" V2.5 Cn = DDEExecute(Cn,"ExecSQL(""SQL "",...") V3.X Cn = DDEExecute(Cn,"[KeyExecSQL(""SQL "",...)]") V3.X KeySQL.MAC 12 KeySQL for Microsoft Windows 5.1

X Cn = DDEInitiate("KEYSQL","SYSTEM") KeySQL DDE [ ] V2.5 Cn = DDEExecute(Cn,"Fetch()") V3.

13 13

14 KeySQL R4.2 R5.0 R5.1 R4.2 R5.0 R5.1 CHAR VARCHAR2 NCHAR NVARCHAR2 ( ) ( ) ( ) ( ) CLOB NCLOB LONG ( ) ( ) NUMBER DATE TIMESTAMP TIMESTAMP WITH TIME ZONE TIMESTAMP WITH LOCAL TIME ZONE INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND RAW LONG RAW ( ) ( ) BLOB ROWID UROWID BFILE NCHAR / NVARCHAR2 / 14 KeySQL for Microsoft Windows 5.1

15 KeySQL -ct -ct KeySQL -ct1 -ct1 KEYSQL_OBJECT$ KEYSQL_OBJECT$ obj_name obj_owner KeySQL KEYSQL_OBJECT$ -ct2 KEYSQL_OBJECT$ -ct1 o SYS SYSTEM -ct1 KEYSQL_OBJECT$ o SYS SYSTEM SYS SYSTEM WHERE OBJ_OWNER NOT IN ('SYS', 'SYSTEM') -ct3 SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER!= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS WHERE OWNER!= 'NET_CONF' AND TABLE_OWNER!= 'NET_CONF' 15

'SYSTEM') -ct3 SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER!

16 SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND TABLE_OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') -ct4 SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER!= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS WHERE OWNER!= 'NET_CONF' SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') -ct5 SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER!= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') 16 KeySQL for Microsoft Windows 5.1

= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS WHERE OWNER!

17 SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND OBJECT_TYPE IN ('TABLE', 'VIEW') -d -d KeySQL Enable KeySQL KEYSQL.LOG -dd -dd DDE -df -df -d -xg -xg -xt -xt 17

18 KeySQL SELECT o SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER!= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS S WHERE OWNER!= 'NET_CONF' AND TABLE_OWNER!= 'NET_CONF' AND EXISTS (SELECT B.OBJECT_NAME FROM ALL_OBJECTS B WHERE S.TABLE_NAME = B.OBJECT_NAME AND B.OWNER!= 'NET_CONF' AND B.OBJECT_TYPE IN ('TABLE','VIEW')) o SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS S WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND TABLE_OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND EXISTS (SELECT B.OBJECT_NAME FROM ALL_OBJECTS B WHERE S.TABLE_NAME = B.OBJECT_NAME AND B.OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND B.OBJECT_TYPE IN ('TABLE','VIEW')) 18 KeySQL for Microsoft Windows 5.1

OBJECT_TYPE IN ('TABLE','VIEW')) o SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM

19 Excel yyyy/m/d KeySQL Excel NCHAR / NVARCHAR2 / Oracle Database 10g Oracle9i Database NCHAR / NVARCHAR2 / Oracle Net Services Oracle8i Database NCHAR / NVARCHAR2 ( ORA ) Excel / / Excel KeySQL Excel UPDATE/DELETE WHERE Error KeySQL Excel EXCEL KeySQL KeySQL ON PEXCEL**.INI KeySQL 19

1 Oracle8i Database NCHAR / NVARCHAR2 ( ORA-12704 ) Excel / / Excel

20 C: KeySQL PEXCEL97.INI KeySQL PEXCEL**.INI ** Excel Excel97 PEXCEL97.INI Excel2000 PEXCEL2000.INI Excel2002 PEXCEL2002.INI Excel2003 PEXCEL2003.INI Dde.Client.NeedBusyCheck= On *1 Dde.Client.BusyCheckInterval= 500 *2 Dde.Client.BusyCheckAfterWait= 500 *3 Dde.Client.BusyCheckRetryCount= 200 *4 Dde.Client.BusyCheckCommand=[MESSAGE(FALSE)] *5 *1 *2 ( ) *3 ( ) *4 *5 (*1 *4 ) Error KeySQL Excel 20 KeySQL for Microsoft Windows 5.1

21 Excel Excel Internet Explorer Netscape Excel Excel 97 VBA + Windows98 Second Edition KeySQL DDEExecute 32-1 String Windows98 Second Edition DDE 63 DDEExecute Cn, "[Select(1,""keysqldb.. 1"",,"" "",,)]" DDEExecute Cn, "[Select(1, ""keysqldb.. 1"",,"" "",,)]" DDEExecute Cn, "[Select(1,""keysqldb.. 1"",,"" "",,)]" 21

KeySQL 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