Question

你好,我用的是PB..输入这个的时候报错..我不晓得是哪哪有问题,请求指点一下,不胜感激

update zctable
set zcdept=sle_3.text
zcresp=sle_4.text
zctype=ddlb_1.text
zcversion=sle_5.text
zcconf=sle_6.text
zcbuyday=sle_8.text
zccost=sle_11.text
gysname=ddlb_2.text
zcsapid=sle_9.text
zcsapday=sle_10.text
zcchangedet=sle_7.text
acbz=sle_2.text
where zcid=sle_1.text;

Answer 1

update zctable
set zcdept=sle_3.text,
zcresp=sle_4.text,
zctype=ddlb_1.text,
zcversion=sle_5.text,
zcconf=sle_6.text,
zcbuyday=sle_8.text,
zccost=sle_11.text,
gysname=ddlb_2.text,
zcsapid=sle_9.text,
zcsapday=sle_10.text,
zcchangedet=sle_7.text,
acbz=sle_2.text
where zcid=sle_1.text;

更新的字段间要用逗号隔开