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