不是我不测试,而是不是语句的问题
set item_一等执行 = '2' 改成 set item_一等执行 = '一' 这句中2是文本,不是数值
这个已经不再测试了,我重新创建了两个表进行测试,还是出现这个问题
//表1 测试update
<p><input classname="cn.myapps.runtime.dynaform.form.ejb.InputField" id="__KieLE1qNrJ2MnBY10Bq" text="text" name="测试" texttype="text" fieldtype="VALUE_TYPE_VARCHAR" fieldkeyevent="Tabkey" layout="horizontal" readonlyshowvalonly="true" discript="" validaterule="" valuescript="" width="" hiddenscript="" hiddenvalue="" hiddenprintscript="" printhiddenvalue="" readonlyscript="" refreshonchanged="false" isdefaultvalue="false" calculateonrefresh="false" mobile="true" secrettext="false" defaultvalueisnull="false" numberpattern="" processdescription="[];[]" filtercondition="" instantvalidate="false" validatelibs="" editmode="01" refreshmode="0" refreshfields="" /><input classname="cn.myapps.runtime.dynaform.form.ejb.InputField" id="__OBj1GRkl6jG75FwVEiI" text="text" name="数据" texttype="text" fieldtype="VALUE_TYPE_VARCHAR" fieldkeyevent="Tabkey" layout="horizontal" readonlyshowvalonly="true" discript="" validaterule="" valuescript="" width="" hiddenscript="" hiddenvalue="" hiddenprintscript="" printhiddenvalue="" readonlyscript="" refreshonchanged="false" isdefaultvalue="false" calculateonrefresh="false" mobile="true" secrettext="false" defaultvalueisnull="false" numberpattern="" processdescription="[];[]" filtercondition="" instantvalidate="false" validatelibs="" editmode="01" refreshmode="0" refreshfields="" /> </p>
<p> </p>
//表2 测试update2
<p><input classname="cn.myapps.runtime.dynaform.form.ejb.InputField" id="__KieLE1qNrJ2MnBY10Bq" text="text" name="测试" texttype="text" fieldtype="VALUE_TYPE_VARCHAR" fieldkeyevent="Tabkey" layout="horizontal" readonlyshowvalonly="true" discript="" validaterule="" valuescript="" width="" hiddenscript="" hiddenvalue="" hiddenprintscript="" printhiddenvalue="" readonlyscript="" refreshonchanged="false" isdefaultvalue="false" calculateonrefresh="false" mobile="true" secrettext="false" defaultvalueisnull="false" numberpattern="" processdescription="[];[]" filtercondition="" instantvalidate="false" validatelibs="" editmode="01" refreshmode="0" refreshfields="" /><input classname="cn.myapps.runtime.dynaform.form.ejb.InputField" id="__OBj1GRkl6jG75FwVEiI" text="text" name="数据" texttype="text" fieldtype="VALUE_TYPE_VARCHAR" fieldkeyevent="Tabkey" layout="horizontal" readonlyshowvalonly="true" discript="" validaterule="" valuescript="" width="" hiddenscript="" hiddenvalue="" hiddenprintscript="" printhiddenvalue="" readonlyscript="" refreshonchanged="false" isdefaultvalue="false" calculateonrefresh="false" mobile="true" secrettext="false" defaultvalueisnull="false" numberpattern="" processdescription="[];[]" filtercondition="" instantvalidate="false" validatelibs="" editmode="01" refreshmode="0" refreshfields="" /> </p>
<p> </p>
//表2 测试update2 保存并新增 动作执行后脚本
(function(){
var cs = getItemValueAsString("测试");
var sj = getItemValueAsString("数据");
var sql="update tlk_测试update set item_数据='"+sj+"' where item_测试 = '"+cs+"'";
updateByDSName("gracemj",sql);
println("测试"+sql);
})()
//表1和表2是同样的表。测试内容为在表2保存时更新表1。实际测试过程中,表2执行到第11行时发生了之前的错误代码
附件中将上传两张表的数据结果 |