Print Page | Close Window

Wildcards are not allowed in the middle of a string?

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=3469
Printed Date: 02-Jun-2025 at 10:30am


Topic: Wildcards are not allowed in the middle of a string?
Posted By: iceinfog
Subject: Wildcards are not allowed in the middle of a string?
Date Posted: 01-Jun-2012 at 2:08am
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.


Replies:
Posted By: sbelini
Date Posted: 01-Jun-2012 at 4:46pm
Hi iceinfog,
 
Unfortunately, DevForce is build on top of the Entity Framework and if it's an EF limitation, then DevForce is also limited by it.
 
Regards,
   Silvio.


Print Page | Close Window