DevForce Community Forum : RdbQuery Error with StartsWith condition http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : RdbQuery Error with StartsWith condition Thu, 11 Jun 2026 03:06:44 -700 Tue, 08 Jul 2008 12:10:35 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=879 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ RdbQuery Error with StartsWith condition : When I create an RdbQuery that... http://www.ideablade.com/forum/forum_posts.asp?TID=879&PID=3188#3188 Author: TimClamp
Subject: 879
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.


Edited by TimClamp - 08-Jul-2008 at 1:34pm]]> Tue, 08 Jul 2008 12:10:35 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=879&PID=3188#3188