执行出错,出错时间:2017-11-23 17:00:26;
错误信息:parse error. detail message is :
Error: expect token
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里面是可以执行的,请大神查看!代码如下
推荐阅读