DBUtils SQL执行报错
金蝶云社区-云社区用户dO743645
云社区用户dO743645
0人赞赏了该文章 2,310次浏览 未经作者许可,禁止转载编辑于2017年11月23日 17:20:38

执行出错,出错时间:2017-11-23 17:00:26;
错误信息:parse error. detail message is :

Error: expect token , but current token is , at line 1, column 387)
source sql is :
insert into T_Self_OrderResponse(FOrgId,FOrderNumber,FSoNumber,FSupplierNo,FCustomerNo,FOrderDate,FMessageDate,FOrderValue,FMaterialId,FPN,FDescription,FMaterialPrice,FResQty,FResDate) select 100002,'DC097-CS-01','0001371491',(select FSUPPLIERID from T_BD_SUPPLIER where FUSEORGID ='100002' and FNUMBER='VEN00012'),'0006601790',CONVERT(date,'20171016'),CONVERT(date,'20171016'),orderValue=CAST('740667'as decimal(18,2)),(select FMATERIALID from t_bd_material where fnumber ='1.01.001' and FUSEORGID ='100002'),'R901065352','M6-1207-00/3M6-15M2V',FMaterialPrice=CAST('551350' as decimal(18,2)),FResQty=CAST('10.000' as decimal(18,2)),CONVERT(date,'20180423');
错误堆栈: 在 Kingdee.BOS.SQL.TransUtil.getStmtList(String ksql)
在 Kingdee.BOS.SQL.TransUtil.Translate(String kSql, Int32 targetDbType, FormatOptions options)
在 Kingdee.BOS.App.Data.AbstractDatabase.CreateCommandByCommandType(CommandType commandType, String commandText, Boolean needTranslate, Int32 commandTimeout)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL)
在 Kingdee.DH.Edi.orderConfirmService.insertXmlInfo(String FileName, Context ctx) 位置 d:\lycCode\lyckingdee\Kingdee.DH.Edi\orderConfirmService.cs:行号 99
在 Kingdee.DH.Edi.orderConfirmService.Run(Context ctx, Schedule schedule) 位置 d:\lycCode\lyckingdee\Kingdee.DH.Edi\orderConfirmService.cs:行号 46
在 Kingdee.BOS.App.Core.ScheduleService.ScheduleService.RunSchedule(Context ctx, Schedule schedule)
出现这个错误,SQL放在sql server里面是可以执行的,请大神查看!代码如下