By use IdeaBlade's EntityQueryOp.Like to Organize sql statement， I found a problem. you can see source as below:
query.AddClause(AccountNumberEntityColumn, EntityQueryOp.Like, accountNumber.ToUpper());
when accountNumber is 'P%', the application is fine
but when accountNumber is 'P%8', the application will pop up a error message:Unhandled exception has occurred in a component in your application. if you click continue, the application will ignore this error and attempt to continue.
In MSDN I found wildcards are not allowed in the middle of a string
so I want to ask a question: IdeaBlade can't allowed wildcards(%) in the middle of a string too?
I hope to get everyone point.
Edited by iceinfog - 01-Jun-2012 at 2:10am