ռƲ⼼
AVIATION METROLOGY & MEASUREMENT TECHNOLOGY
1999ꡡ196ڡVol.19No.61999



ռϢϵͳ
ORACLE6Ӧ
¡
ժҪҪ˺ռϢϵͳORACLE6ӦORACLE7ĹһЩͽ취ԼЧ
ؼʡϢӦ
Upgrade of Applicable Software of Aviation Metrology
Information Managing System
Wang Xin,Li Tao
AbstractThis paper describes some problems met during the upgrade of applicable software of information managing system of aviation metrology,their solving methods and the effect after upgrade.
Key wordsMetrology,Information management,Applicable software,Upgrade
ORACLEݿֲԺãݴǿûѺõһЩصӮڶҵںռϢϵͳҲѡORACLEݿ⡣ǰڿӦMS-DOSϵͳΪƽ̨ORACLE6ϵݿΪĵģΪӦִķչҪӦWINDOWSΪƽ̨ORACLE7ϵݿΪĵֽܺռϢϵͳֲʹõһЩͬ̽֡
1ϵͳл
ʵʩϵͳлORACLE7ϵݿǲClientServer(ͻ)ϵṹνͻǷֲʽʵ֡ڿͻ£ͨӵĿͻͷϡһ򵥵Ŀͻһ̨ΪΪͻÿ̨ɲͬĹܡֽϵͳ£
ϵͳNOVELL NETWAREϵͳԼWINDOWS
ӦORACLE DEVELOPER2000Ӧ
ݿϵͳORACLE7 SERVER FOR NETWARE V7.0ϵݿ⡣
2ϵͳֲгֵʩ
2.1繤վ
ORACLE V6.0AϵݿӦNOVELL NETWAREĹվ(WSGEN)ɵ繤վʹãORACLE 7 SERVER FOR NETWARE V7.0ϵݿӦ(ORACLE DEVELOPER2000)ڴվʹãҪNETWARE 3.12 CLIENT FOR DOSWINDOWS繤վ繤վODI(ݽӿ)ʽORACLE V6.0AӦȻá
2.2ORACLE V6.0AORACLE DEVELOPER2000Ӧó
ԭϵͳMS-DOSΪƽ̨ORACLE V6.0AϵݿģҪΪWINDOWSΪƽ̨¼Ĺ
1)
ORACLE SQL*FORMS 3.0һFORMµOBJECTSFORMBLOCKFIELDTRIGGERFORM-LEVELPROCEDUREˣڶѯģʱȶһƿ飬ɸѯֶΣȻٶKEY-EXEQRYPER-QUERYִвѯ
KEY-EXEQRYPER-QUERYӣPLSQLֱΪ
Trigger text:go-block()
execute-query
Trigger text:copy(name-in(ֶ1)ֶ2)
ORACLE FORMS 4.5пBUTTONORACLE SOL*FORMS 3.0жKEYΪBUTTONPLSQL䲻䣬ʹֱۡ
2)LOV(ֵ)Ķ
ORACLE V6.0ASQL*FORMS 3.0жLOVǲõûķʽʵֵģ磺ڶֵʱõûķʽLIST OF VALUES SQL TEXT£
select  into  (FIELDS) from 
ORACLE DEVELOPER2000пɸݲͬҪ塣磺ֵɸ̶ֵͨбֶ(LIST ITEM)ʵ֣ھ̬ʽֵҪԴıı䣬ɶLOVڶ̬ʽͬһLOVֶ֧ıLOVкϷ顣
3)˵ĵ
ORACLE V6.0ASQL*MENUƵĲ˵ɶУORACLE DEVELOPER2000ҪͨFORMMENU MODULEá
4)ֶεΨһ
ORACLE V6.0AжʱֶͨεΨһԡ
磺SQLCREATE UNIQUE INDEX  ON (Ψһֶ)
ORACLE DEVELOPER2000пֱӶֶεΨһԡ
5)ORACLE DEVELOPER2000ڵĽ취
ȫļ2000ڵת⣬˱ϵͳеҲ⡣ORACLEϵݿⶨȱʡڸʽΪDD-MON-YYֻռλڱϵͳڸʽΪDD-MON-YYYYʽ
6)ļ
ORACLE 6.0A SQL*FORM3.0Ƶıļ(.INP)ͨF45RUN[MODULE-NAME][û]UPGRADE=YESWIDEN-FIELDS=YESΪDEVELOPER2000еıļ(.FMB).ȻıУҶĹԭһֲܴҪ޸ģ˲˲ȡַʽơ
7)Ӧñ
ORACLE V6.0A SQL*REPORTWRITER 1.1Ƶıļ(.REX)ͨR25MREP.EXEΪORACLE DEVELOPER2000еıļ(.RDF).SCREENʾԭһPREVIEWER(ģʾ)PRINTERʽʾʹӡʱԭƲͬˣӦơ
8)ݵԵʵ
ڱϵͳУORACLE V6.0Aʵֻ֮ĹͨʵֵģORACLE 7 SERVER FOR NETWARE V7.0пֶͨεⲿʵ֡
3Ӧϵз
ORACLE V6.0A UTILITYӦIMP()EXP(ж)ORACLE DEVELOPER2000Ӧ޴ֻORACLE 7 SERVER FOR NETWARE V7.0.ʹãORACLE 7װڷϵģ˶ݿṩõİȫʩ
ORACLE V6.0A SQL*FORMS 3.0SQLREPORTļͨHOSTHOSTDOSƽ̨ϵ󳤶Ϊ127ֽڣ˲Ĵݣ磺
HOST(RUNREP·\û
DESTYPE=FILE
=NO-SCREEN)
ORACLE DEVELOPER2000пͨڱģ֮䴫ݺͲһPLSQLڼɡдŵҪݵĲƺֵ
ORACLE REPORTS 2.5ʹPLSQL䶨崥ӣSQL*REPORTWRITER1.1ûСʹ䣬㲻ͬû
ORACLE V6.0AݿORACLE V7.0ݿֲУעַƥ⣬NATIONAL LANGUAGE SUPPORTҪһ¡
߼:¡31ꡡСʦ
ߵλ:Ǽо1066䣬100095
ο
1ORACLE DEVELOPER2000Эͬ(CDE2)
2ORACLE DEVELOPER2000ʹü뷽
3ORACLE V7ֲ
4NOVELL NETWARE 386 V3.11
5WINDOWS 95ʹôȫ
1998-07-03ո
