Print Page | Close Window

RdbQuery Error with StartsWith condition

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=879
Printed Date: 11-Jun-2026 at 3:07am


Topic: RdbQuery Error with StartsWith condition
Posted By: TimClamp
Subject: RdbQuery Error with StartsWith condition
Date Posted: 08-Jul-2008 at 12:10pm
When I create an RdbQuery that contains a StartsWith condition, and the value used in the operation contains a '[' character, such as 'AABAAAAABAAAAA[', I receive an error down in the bowels of System.Data.LikeNode that states:
 
System.Data.EvaluateException was unhandled: the string pattern is AABAAAAABAAAAA[[[]]% invalid
 
It appears that DevForce is trying to escape the '[' character as required by the datacolumn expression in System.Data, however it appears that the escape sequence is failing miserably somewhere.


Print Page | Close Window