kwcR3.0 Release Note

Size: px

Start display at page:

Download "kwcR3.0 Release Note"

ぜんまのたけ
7 years ago
Views:

2 KeySQL R4.2 KeySQL 2 KeySQL R4.2

3 KeySQL R X R4.X X NCHAR / NVARCHAR2 /

4 Microsoft Windows 95/98/ Windows NT4.0/2000/XP Professional OS Oracle (Net8 ) OS DBMS OS CD-ROM CPU Microsoft Windows NT4.0/2000/XP Professional Microsoft Windows 95/98 2M 4M KeySQL 2MB KeySQL CD-ROM 4 KeySQL R4.2

5 Windows Administrator KeySQL R KeySQL R4.2 MAC VBA KeySQL 2. KeySQL 3. KeySQL R KeySQL R MAC 5

6 KeySQL R4.1 Windows Administrator KeySQL R4.2 Terminal Service MS Windows Terminal Service KeySQL 4000 KeySQL Ctrl-C 6 KeySQL R4.2

7 3.X R4.X Excel2000 Excel2000 TNSNAME Windows2000 Windows2000 7

8 HTML HTML CSV CSV SQL KeySQL SQL / 8 KeySQL R4.2

9 Excel 97 SQL " - - " " "," " Having "(EMP.SAL+EMP.SAL)* 2 > 0" () KeySQL VBA V3.X KeySQL 9

10 2.5 3.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 10 KeySQL R4.2

5 Cn = DDEExecute(Cn,"Fetch()") V3.X Cn = DDEExecute(Cn,"[Fetch()]") SQL "ExecSQL" "KeyExecSQL" V2.

11 11

12 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') 12 KeySQL R4.2

-ct2 KEYSQL_OBJECT$ -ct1 o SYS SYSTEM -ct1 KEYSQL_OBJECT$ o

13 -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' 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') 13

14 -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') 14 KeySQL R4.2

= 'NET_CONF' SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER NOT IN ('SYS', 'SYSTEM',

15 -ct5 SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER!= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') 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 15

OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER NOT IN ('SYS', 'SYSTEM',

16 -df -df -d -xg -xg -xt -xt 16 KeySQL R4.2

17 KeySQL SELECT 17

18 18 KeySQL R4.2

19 Excel yyyy/m/d KeySQL Excel NCHAR / NVARCHAR2 / 9i NCHAR / NVARCHAR2 / Oracle Net 9.0 8i NCHAR / NVARCHAR2 (ORA ) 19

20 Excel Excel 97 VBA + Windows95/98 KeySQL DDEExecute 32-1 String Windows95/98 DDE 63 DDEExecute Cn, "[Select(1,""keysqldb.. 1"",,"" "",,)]" DDEExecute Cn, "[Select(1, ""keysqldb.. 1"",,"" "",,)]" DDEExecute Cn, "[Select(1,""keysqldb.. 1"",,"" "",,)]" 20 KeySQL R4.2

. 1"",,"" "",,)]" 10 20 30 40 50 60 DDEExecute Cn, "[Select(1,

KeySQL R5.1 Release Note

KeySQL 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,