This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I have read a few posts on using the likeOperator to do some searching. The below statement works fine but I need to do a case insensitive search on my DB. If I add in toLower() to the mix i get a lightspeed error, Can you help me understand what i'm doing wrong. where LikeOperator.LikeString(y.SomeFeild, criteria, CompareMethod.Text) where LikeOperator.LikeString(y.SomeFeild.ToLower(), criteria, CompareMethod.Text)
at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource) |
|
|
|
|
You're doing nothing wrong -- it appears we have a bug in our handling of nested method calls with zero arguments (in your case, the nesting of ToLower() inside LikeString()). I've implemented a fix and it will be in the next nightly build, available from about 1200 GMT. Thanks for letting us know about this, and let us know if you still see problems after upgrading to the nightly. |
|
|
|
|
Thanks, What time will the nightly build be available? |
|
|
|
|
About 1200 GMT/UTC (about 8 hours from now), on the Downloads page (Express edition) or in the store (Professional edition). |
|
|
|
|
Hi Ivan, I downloaded the latest build version 3.1.2476.16161 and I'm getting the same error: Stack Trace: at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource) at System.ThrowHelper.ThrowArgumentOutOfRangeException() at System.SZArrayHelper.get_Item[T](Int32 index) at System.Collections.ObjectModel.ReadOnlyCollection`1.get_Item(Int32 index) at Mindscape.LightSpeed.Linq.Sqo.Where.IsSubQuery(Expression expression) at Mindscape.LightSpeed.Linq.Sqo.Where.IsSubQuery(Expression expression) at Mindscape.LightSpeed.Linq.Sqo.Where.IsSubQuery(Expression expression) at Mindscape.LightSpeed.Linq.Sqo.Where.IsSubQuery(Expression expression) at Mindscape.LightSpeed.Linq.Sqo.Where.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp) at Mindscape.LightSpeed.Linq.Sqo.Where.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp) at Mindscape.LightSpeed.Linq.Sqo.Where.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp) at Mindscape.LightSpeed.Linq.Sqo.Where.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp) at Mindscape.LightSpeed.Linq.Sqo.Select.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp) at Mindscape.LightSpeed.Linq.Sqo.Where.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp) at Mindscape.LightSpeed.Linq.Sqo.Take.Evaluate(ExpressionVisitor visitor, MethodCallExpression expression) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.VisitMethodCall(MethodCallExpression exp) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Visit(Expression exp) at Mindscape.LightSpeed.Linq.Plan.LinqQueryBuilder.Build(Expression translation, LinqQueryProvider provider) at Mindscape.LightSpeed.Linq.LinqQueryProvider.GetExecutionPlan(Expression expression) at Mindscape.LightSpeed.Linq.LinqQueryProvider.Execute(Expression expression) at Mindscape.LightSpeed.Linq.LinqQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression) at Mindscape.LightSpeed.Linq.LinqQuery`1.GetEnumerator() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at
Can you confirm that you have fixed this bug? Thanks Again, |
|
|
|
|
Many apologies -- we had a (spurious) test failure which meant the fix didn't get folded into the nightly build. Barring further problems, it should be in the next nightly. Again, sorry for the inconvenience. |
|
|
|
|
hmmm ok, but it will definatly be in the build tomorrow? |
|
|
|
|
Actually I'm kinda under the pump here, is there anyway you cvould provide me the DLL's earlier than tomorrow? |
|
|
|
|
We'll aim to get an update on the Web site in the next couple of hours -- but I can't promise for certain. |
|
|
|
|
Thanks Ivan, let me know when i can download it :-) |
|
|
|
|
Hi James, It's up on the site now. Let us know if you still see problems. |
|
|
|
