用Sql*forms3.0开发Oracle报表应用  

Developing the Oracle Form Application with SQL＊Forms3.0

作　　者：顾正华[1] 赵致格[1] 

机构地区：[1]清华大学计算机系CAD教研组,北京100084

出　　处：《计算机工程与应用》1999年第5期67-69,共3页Computer Engineering and Applications

摘　　要：文章要说明的主要是在Sql＊forms3．0中利用附加码进行主从结构报表的设计和开发的方法。该方法的目的是解决主从表结构中主码较多时从表域过多，以及主码项不能修改的问题。这个方法的主要特点在于利用一个附加的域作为主表和从表的唯一约束，每张报表产生一个唯一的值，从表的所有记录通过这个值来标识，而这个域的值的产生又比较容易。通过这一方法，在实际应用中较好地解决了主从表应用中的问题。This paper proposes a method for designing and developing the master-detail forms using additionalfield in sql*forms3.0. rFhe objective is to find a solution to the problem that too many fields exists and keywords of table can't be modified when there are lots of keywords in master-detail strUcture. To employ an additional field as the only foreign key of master table and detail table is tile main feature of this solution. Everyreport form can generate a single value by which all the records in detail table are idenhfied. Tile proposal hasbeen realized and it's application demonstrates that the problem presented alcove can be resolved effectively.

关 键 词：电厂化学 报表 ORACLE Sql＊forms3.0 数据库 

分 类 号：TM621.8[电气工程—电力系统及自动化] TP311.13[自动化与计算机技术—计算机软件与理论]