Oracle form 与javascript对html的Checkbox处理与应用 下载本文

Oracle form 与javascript对html的Checkbox处理与应用

Checkbox属于HTML的IPNUT标签的一个TYPE之一,开发过程中它有着广泛应用,在

ORACLEas开发网页过程中它有很强特点,体现在存储过程参数传递过程中。 在网页设置构成中有几个type=\的input标签,js通过var

aCh=document.getElementsByName(\获取的数组length的长度为网页中input的个数,而在oracle

CREATE OR REPLACE PROCEDURE WPRTL.ls_edit_del_tmcode(lb1 IN VARCHAR2 DEFAULT NULL) IS

vre0 number; vre1 number;

my_row dvlpr.t_main_config_x%rowtype; vtmcode dvlpr.t_sptm.tmcode%type; CURSOR cur_rs IS

SELECT b.tmcode FROM (SELECT lb

FROM dvlpr.t_main_config_x WHERE lb = lb1) a, dvlpr.t_sptm b WHERE a.lb = b.lb; BEGIN NULL;

HTP.p (format.pagestart ('商品档案(删除条码)管理')); HTP.p (htmlform.formstart ('')); HTP.p ( '

商品档案条码修改系统

href=\target=_blank>  关键字模糊查询

');

SELECT COUNT (*) INTO vre0

FROM dvlpr.t_main_config_x WHERE lb = lb1;

IF vre0 = 1 THEN SELECT * INTO my_row

FROM dvlpr.t_main_config_x WHERE lb = lb1; SELECT COUNT (*) INTO vre1 FROM (SELECT lb

FROM dvlpr.t_main_config_x WHERE lb = lb1) a, dvlpr.t_sptm b WHERE a.lb = b.lb; HTP.p

( '

' );

vre1:=vre1+1; HTP.p( '

FOR v_emp IN cur_rs LOOP HTP.p('