值脚本为
var bianhao= getItemValueAsString("用户编号");
var mingcheng= getItemValueAsString("用户名称");
var sql = "select custname from customers where custcode='"+bianhao+"'";
var datas = queryByDSName("xinxi",sql);
if(datas!=null && datas.size()>0){
for(var iter = datas.iterator();iter.hasNext();){
var doc = iter.next();
}
mingcheng=doc.getItemValueAsString("custname");
}
var bianhao= getItemValueAsString("用户编号"); //得到表单中的字段的值
var mingcheng= getItemValueAsString("用户名称"); //得到表单中的字段的值
var sql = "select custname from customers where custcode='"+bianhao+"'"; //查出我自己再数据库中创建的表customers中的custcode='"+bianhao+"'"的那一行的 custname的值
var datas = queryByDSName("xinxi",sql);
if(datas!=null && datas.size()>0){
for(var iter = datas.iterator();iter.hasNext();){
var doc = iter.next();
mingcheng=doc.getItemValueAsString("custname"); //用数据库中中查出来的数据custname的值把当前表单的 用户名称 的字段覆盖掉
var bianhao= getItemValueAsString("用户编号"); //得到表单中的字段的值
var rut1="";
var rut2="用户编号不存在";
var sql = "select custname from customers where custcode='"+bianhao+"'"; //查出我自己再数据库中创建的表customers中的custcode='"+bianhao+"'"的那一行的 custname的值
var datas = queryByDSName("xinxi",sql);
if(datas!=null && datas.size()>0){
for(var iter = datas.iterator();iter.hasNext();){
var doc = iter.next();
rut1=doc.getItemValueAsString("custname"); //用数据库中中查出来的数据custname的值把当前表单的 用户名称 的字段覆盖掉
我的值脚本
var bianhao= getItemValueAsString("用户编号");
var mingcheng="";
var run=" ";
var sql = "select custname as item_custname,custcode as item_custcode from customers where item_custcode='"+bianhao+"'";
var datas = queryByDSName("obpm",sql);
if(datas!=null && datas.size()>0){
for(var iter = datas.iterator();iter.hasNext();){
var doc = iter.next();
mingcheng=doc.getItemValueAsString("item_custname");
}
mingcheng;
}else
run;
所报的错