Return
-
Title
Resultset filtering on a date column gives error -
Description
Run a select on the editor that returns a date column.
Then try to filter the date column in the grid with Toad.
Toad for SAP returns the error below:DevExpress.Data.Filtering.CriteriaCompilerException
Error 'No coercion operator is defined between types 'Quest.Toad.SAP.Types.SybaseDate' and 'System.DateTime'.' at '[StartDate] = #2018-01-09#' compiling criteria '[StartDate] = #2018-01-09# Or [StartDate] = #2018-01-02#'
Stack Trace:
at DevExpress.Data.Filtering.Helpers.CriteriaCompilerCore.Compile(CriteriaCompilerDescriptor descriptor, CriteriaCompilerAuxSettings settings, CriteriaOperator op)
at DevExpress.Data.DataControllerBase.ValidateExpression(CriteriaOperator op)
at DevExpress.XtraGrid.Views.Base.ColumnView.ApplyColumnsFilterCore(Boolean updateMRU, Boolean ignoreActiveFilter)
at DevExpress.XtraGrid.Views.Base.ColumnView.ApplyColumnsFilter()
at Quest.Toad.Grid.ToadGridControl.ToadGridView.ApplyColumnsFilter()System.InvalidOperationException
No coercion operator is defined between types 'Quest.Toad.SAP.Types.SybaseDate' and 'System.DateTime'.
Stack Trace:
at System.Linq.Expressions.Expression.GetUserDefinedCoercionOrThrow(ExpressionType coercionType, Expression expression, Type convertToType)
at System.Linq.Expressions.Expression.Convert(Expression expression, Type type, MethodInfo method)
at DevExpress.Data.Filtering.Helpers.CriteriaCompilerCore.MakeCompare(Expression left, Expression right, Boolean isEqualsCompare, Func`2 postCmpLambda, Func`3 directCmp, CriteriaCompilerAuxSettings auxSettings)
at DevExpress.Data.Filtering.Helpers.CriteriaCompilerCore.DevExpress.Data.Filtering.ICriteriaVisitor.Visit(BinaryOperator theOperator)
at DevExpress.Data.Filtering.BinaryOperator.Accept[T](ICriteriaVisitor`1 visitor)
at DevExpress.Data.Filtering.Helpers.CriteriaCompilerCore.Process(CriteriaOperator criteria)
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.