SQL在数据库执行是没有问题的，但是在插件中执行就报错：

Kingdee.BOS.SQL.Exception.ParserException

HResult=0x80131500

Message=parse error. detail message is :

Error: expect token <Punctuation,)>, but current token is <Keyword,as>, at line 1, column 279)

source sql is :

/*dialect*/ select sum(isnull(t.FQTY,0)) as qtys from T_STK_MISDELIVERYENTRY t inner join T_STK_MISDELIVERY t1 on t.FID = t1.FID where t1.FDATE >=(case when day('2020-10-31 20:25:06') > 25 then (case when month('2020-10-31 20:25:06') = 1 then cast(year('2020-10-31 20:25:06') - 1 as varchar) + '-12-26' else cast(year('2020-10-31 20:25:06') as varchar) + '-' + cast(month('2020-10-31 20:25:06') - 1 as varchar) + '-26' end) else (case when month('2020-10-31 20:25:06')= 1 then cast(year('2020-10-31 20:25:06')-1 as varchar)+'-11-26' when month('2020-10-31 20:25:06')= 2 then cast(year('2020-10-31 20:25:06')-1 as varchar)+'-12-26' else cast(year('2020-10-31 20:25:06') as varchar) + '-' + cast(month('2020-10-31 20:25:06') - 2 as varchar) + '-26' end) end ) and t1.FDATE <= (case when day('2020-10-31 20:25:06')> 25 then cast(year('2020-10-31 20:25:06') as varchar)+'-' + cast(month('2020-10-31 20:25:06') as varchar) + '-25' else (case when month('2020-10-31 20:25:06')= 1 then cast(year('2020-10-31 20:25:06')-1 as varchar)+'-12-25' else cast(year('2020-10-31 20:25:06') as varchar) + '-' + cast(month('2020-10-31 20:25:06') - 1 as varchar) + '-25' end) end) and t1.FDEPTID = '107354' and t.FMATERIALID = '278003'

Source=Kingdee.BOS.SQL

StackTrace:

at Kingdee.BOS.SQL.TransUtil.getStmtList(String ksql)

at Kingdee.BOS.SQL.TransUtil.Translate(String kSql, Int32 targetDbType, FormatOptions options)

at Kingdee.BOS.SQL.TransUtil.Translate(String ksql, Int32 targetDbType)

at Kingdee.BOS.App.Data.AbstractDatabase.CreateCommandByCommandType(CommandType commandType, String commandText, Boolean needTranslate, Int32 commandTimeout)

at Kingdee.BOS.App.Data.AbstractDatabase.CreateCommandByCommandType(CommandType commandType, String commandText, Int32 commandTimeout)

at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior, Boolean bNewCn)

at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, Boolean bNewCn)

at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, CommandType cmdtype, Boolean bNewCn)

at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL)

at qlzkCustomBill.BusinessPlugIn.getShangyueHaoyongQtys.DataChanged(DataChangedEventArgs e) in D:\WorkSpace-cloud\zhongkuang\Code\qlzkCustomBill.BusinessPlugIn\getShangyueHaoyongQtys.cs:line 132

at Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormModelPlugInProxy.FireDataChanged(DataChangedEventArgs e)

at Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormModel.OnDataChanged(DataChangedEventArgs arg)

at Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormModel.UpdateFieldValue(Field field, DynamicObject obj, Object value, Int32 row)

at Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormModel.UpdateField(Field field, DynamicObject activeRow, Object value, Int32 rowIndex, Object oldValue)

at Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormModel.SetValue(Field field, DynamicObject activeRow, Object value, Int32 rowIndex)

at Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormModel.SetValue(Field field, Object value, Int32 row)

at Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormModel.SetValue(String key, Object value, Int32 row)

at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.DoLookUpSetFieldValue(FieldAppearance ap, ILookUpField lookUpField, Int32 rowIndex, ListSelectedRow selectRow, String combinedFieldKey)

at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.DoLookUpAfterShow(String key, Int32 row, ILookUpField lookUpField, FieldAppearance ap, FormResult result, String combinedFieldKey)

at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.<>c__DisplayClassa2.<DoLookUpFieldButtonClick>b__a1(FormResult result)

at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.<>c__DisplayClass6b.<FormClosedCallBack>b__68()

此异常最初是在此调用堆栈中引发的:

[外部代码]

内部异常 1:

ParserException:

Error: expect token <Punctuation,)>, but current token is <Keyword,as>, at line 1, column 279)

产品问题Error: expect token <Punctuation,)>, but current token is <K

产品问题 Error: expect token <Punctuation,)>, but current token is <K

恭喜您！

产品问题
Error: expect token <Punctuation,)>, but current token is <K