显示这个 我的下拉框编辑结束事件的js是: var third=this.getValue();//三级名称 setTimeout(function(){ var result; var sql='with c as(SELECT * FROM dim_fr_cw_accountingsubject a WHERE a.levelid = 03 AND a.name = "'+third+'"),d as (SELECT * FROM dim_fr_cw_accountingsubject a WHERE a.levelid = 04) SELECT d.name as fourthname FROM c LEFT JOIN d on c.id = d.pid'; result=FR.remoteEvaluate("=sql('GANGLONG','"+sql+"',1,1)"); alert(result); },200); |