New Posts New Posts RSS Feed: Wildcards are not allowed in the middle of a string?
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Wildcards are not allowed in the middle of a string?
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
iceinfog View Drop Down
Newbie
Newbie


Joined: 01-Jun-2012
Posts: 1 		Post Options Post Options   Quote iceinfog Quote  Post ReplyReply Direct Link To This Post Topic: Wildcards are not allowed in the middle of a string?
    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.



Edited by iceinfog - 01-Jun-2012 at 2:10am
Back to Top
sbelini View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 13-Aug-2010
Location: Oakland
Posts: 786 		Post Options Post Options   Quote sbelini Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down