SQL 错误
金蝶云社区-云社区用户159e1234
云社区用户159e1234
0人赞赏了该文章 2,143次浏览 未经作者许可,禁止转载编辑于2014年07月21日 10:41:53

现做一个发货通知单数量更新功能,但是在操作执行SQL代码是提示错误:parse error. detail message is :

Error: expect token , but current token is , at line 1, column 16)
source sql is :
update b set b.fbasedeliqty=b.fbasedeliqty-(v.fqty-v.fjoinoutqty),b.fdeliqty=b.fdeliqty-(v.fqty-v.fjoinoutqty),b.fcanoutqty=b.fcanoutqty+(v.fqty-v.fjoinoutqty),b.fbasecanoutqty=b.fbasecanoutqty+(v.fqty-v.fjoinoutqty)
from T_SAL_ORDER a inner join T_SAL_ORDERENTRY_R b on a.fid=b.fid inner join
(select b.FOrderNo,b.FORDERSEQ,b.fqty,b.fjoinoutqty from T_SAL_DELIVERYNOTICE a inner join T_SAL_DELIVERYNOTICEENTRY b on a.fid=b.fid and a.fbillno='00000046') v
on a.fbillno=v.forderno and b.fentryid=v.forderseq

以上代码数据库中直接执行能通过,可是在插件中就过不了,请老师帮帮提点下
原始代码: string SQL = string.Format(@" update b set b.fbasedeliqty=b.fbasedeliqty-(v.fqty-v.fjoinoutqty),b.fdeliqty=b.fdeliqty-(v.fqty-v.fjoinoutqty),b.fcanoutqty=b.fcanoutqty+(v.fqty-v.fjoinoutqty),b.fbasecanoutqty=b.fbasecanoutqty+(v.fqty-v.fjoinoutqty)
from T_SAL_ORDER a inner join T_SAL_ORDERENTRY_R b on a.fid=b.fid inner join
(select b.FOrderNo,b.FORDERSEQ,b.fqty,b.fjoinoutqty from T_SAL_DELIVERYNOTICE a inner join T_SAL_DELIVERYNOTICEENTRY b on a.fid=b.fid and a.fbillno='{0}') v
on a.fbillno=v.forderno and b.fentryid=v.forderseq",fbillno);
int i=DBUtils.Execute(this.Context, SQL);