')'附近有语法错误,求助!!
金蝶云社区-汪乐
汪乐
0人赞赏了该文章 3,140次浏览 未经作者许可,禁止转载编辑于2014年03月03日 17:30:56
求助一下
我在启用存货核算系统的时候 它老是报“)”语法错误 就第一个错误 其他的都能启用成功


生时间: 2014-03-03 05:33:09
错误编号: BOS_ExecuteNonQuery
错误信息: ')' 附近有语法错误。
Sql语句: SELECT payentry.FEntryId fbillentryid, fin.FMAINBOOKSTDCURRID fcurrid, fin.FEXCHANGETYPE fratetype, pay.FDATE, payentry.FNOTAXAMOUNT famount, pay.FSETTLEORGID, payentry.FNOTAXAMOUNT facctgamount, dime.FENTRYID fstockdimeentryid, stockDim.FDIMEENTRYID, pay.FBillTypeId, pay.FID fbillid, pay.FBillNo, payentry.FSeq fbillseqid INTO tmpd37d0300a2b611e398ddc0cb38f FROM T_AP_BILLINGMATCHLOGEntry billog INNER JOIN T_AP_PAYABLE balancepay ON billog.FTARGETBILLID = balancepay.FID INNER JOIN T_AP_PAYABLEENTRY payentry ON billog.FSRCROWID = payentry.FENTRYID INNER JOIN T_AP_PAYABLEENTRY_O o ON o.FENTRYID = payentry.FENTRYID INNER JOIN T_AP_PAYABLE pay ON pay.FID = payentry.FID INNER JOIN T_AP_PAYABLEFIN fin ON pay.FID = fin.FID INNER JOIN (SELECT stock.FMATERIALID, stock.FLOT, stock.FAUXPROPID, min(stock.FENTRYID) fentryid FROM T_HS_InivStockDimension stock INNER JOIN T_HS_StockDimension acctgdmie ON stock.FDIMEENTRYID = acctgdmie.FENTRYID WHERE acctgdmie.FISENABLE = '1' GROUP BY stock.FMATERIALID, stock.FLOT, stock.FAUXPROPID) dime ON ((payentry.FMATERIALID = dime.FMATERIALID AND o.FLOT = dime.FLOT) AND o.FAUXPROPID = dime.FAUXPROPID) INNER JOIN T_HS_InivStockDimension stockDim ON stockDim.FENTRYID = dime.FENTRYID WHERE (((((billog.FISADIBILL = '1' AND billog.FTARGETFROMID = 'AP_Payable') AND balancepay.FISINIT = '1') AND (pay.FDATE >= CONVERT(DATETIME, '2013-08-01 00:00:00'))) AND (pay.FDATE < CONVERT(DATETIME, '2013-09-01 00:00:00'))) AND pay.FSETTLEORGID IN ())
===================================================
调用堆栈:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList)
at Kingdee.K3.FIN.App.Core.Match.AcctgBalance.BalanceMatch.GetApData(Context ctx, OutStockAcctgParameters para, String filter, SqlParam[] sqlparas)
at Kingdee.K3.FIN.App.Core.Match.AcctgBalance.BalanceMatch.GetApDataToAcctg(Context ctx, OutStockAcctgParameters para, IOperationResult operationResult)
at Kingdee.K3.FIN.App.Core.Match.AcctgBalance.BalanceMatch.BalanceMatchAcctg(Context ctx, OutStockAcctgParameters acctgPara)
at Kingdee.K3.FIN.HS.App.Core.HookService.WizardCalMaterialCost(Context ctx, List`1 paraList)
at Kingdee.K3.FIN.HS.App.Core.StartEnableHSService.CalCost(Context ctx, Int64 acctSystemId, Int64 acctOrgId, Int64 acctPolicyId, Int32 year, Int32 period)
at Kingdee.K3.FIN.HS.App.Core.StartEnableHSService.EnableHS(Context ctx, HSStartObject startObj)
at Kingdee.K3.FIN.HS.ServiceHelper.StartEnableHSHelper.EnableHS(Context ctx, HSStartObject startObj)
at Kingdee.K3.FIN.HS.Business.PlugIn.StartEnableHS.EnableHS(HSStartObject startObj)
at Kingdee.K3.FIN.Business.PlugIn.CostRelated.AbstractStartEnableEdit.StartHS()
at Kingdee.K3.FIN.Business.PlugIn.CostRelated.AbstractStartEnableEdit.AfterBarItemClick(AfterBarItemClickEventArgs e)
at Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireAfterBarItemClick(AfterBarItemClickEventArgs e)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.BarItemClick(String parentKey, String barItemKey, BarDataManager bar, Int32 bartype)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.MainBarItemClick(String barItemKey)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.MainBarItemClick(String itemKey, JSONArray postDatas)