19. 更新表格字段的值

var rs=LB_sqlResultSet("select WZSX,WZMC,GGXH,DJ,ZKL,SJDJ,CGJLDW,CGJLDWSL,PZ,HSL,JLDW,DHSL,JE,JHRQ,FHRQ,ZP,SLC,SLD,SL,SJHSDJ,SE,JSHJ,Protype from TB_P_ContractAud_BDMX where TB_P_ContractAud_ID=‘"+O_PARAMETER.VContract+"‘");
var ho=O_THIS.getColumn("BDMX").getHypotObject();
var row;
rs.beforeFirst();
row=ho.getObject();
var tmp;
var i=1;
while((row=ho.getObject())==null){
while(rs.next()){
var hoo=ho.getObjectInfo();
hoo.getColumn("WZSX").setValue(rs.getString("WZSX")==null?" ":rs.getString("WZSX"));
hoo.getColumn("WZMC").setValue(rs.getString("WZMC")==null?" ":rs.getString("WZMC"));
hoo.getColumn("GGXH").setValue(rs.getString("GGXH")==null?" ":rs.getString("GGXH"));
hoo.getColumn("DJ").setValue(rs.getString("DJ")==null?" ":rs.getString("DJ"));
hoo.getColumn("ZKL").setValue(rs.getString("ZKL")==null?" ":rs.getString("ZKL"));
hoo.getColumn("SJDJ").setValue(rs.getString("SJDJ")==null?" ":rs.getString("SJDJ"));
hoo.getColumn("CGJLDW").setValue(rs.getString("CGJLDW")==null?" ":rs.getString("CGJLDW"));
hoo.getColumn("CGJLDWSL").setValue(rs.getString("CGJLDWSL")==null?" ":rs.getString("CGJLDWSL"));
hoo.getColumn("PZ").setValue(rs.getString("PZ")==null?" ":rs.getString("PZ"));
hoo.getColumn("HSL").setValue(rs.getString("HSL")==null?" ":rs.getString("HSL"));
hoo.getColumn("JLDW").setValue(rs.getString("JLDW")==null?" ":rs.getString("JLDW"));
hoo.getColumn("ZP").setValue(rs.getString("ZP")==null?" ":rs.getString("ZP"));
hoo.getColumn("DHSL").setValue(rs.getString("DHSL")==null?" ":rs.getString("DHSL"));
hoo.getColumn("JE").setValue(rs.getString("JE")==null?" ":rs.getString("JE"));
hoo.getColumn("JHRQ").setValue(rs.getString("JHRQ")==null?" ":rs.getString("JHRQ"));
hoo.getColumn("FHRQ").setValue(rs.getString("FHRQ")==null?" ":rs.getString("FHRQ"));
hoo.getColumn("SLC").setValue(rs.getString("SLC")==null?" ":rs.getString("SLC"));
hoo.getColumn("SLD").setValue(rs.getString("SLD")==null?" ":rs.getString("SLD"));
hoo.getColumn("SL").setValue(rs.getString("SL")==null?" ":rs.getString("SL"));
hoo.getColumn("SJHSDJ").setValue(rs.getString("SJHSDJ")==null?" ":rs.getString("SJHSDJ"));
hoo.getColumn("SE").setValue(rs.getString("SE")==null?" ":rs.getString("SE"));
hoo.getColumn("JSHJ").setValue(rs.getString("JSHJ")==null?" ":rs.getString("JSHJ"));
hoo.getColumn("Protype").setValue(rs.getString("Protype")==null?" ":rs.getString("Protype"));
hoo.getColumn("Fno").setValue(i++);
ho.appendRecord(hoo);
};
};
ho;

19. 更新表格字段的值

原文：http://www.cnblogs.com/zkx4213/p/4972920.html