jav
Posts: 8
|
| Posted: 10/02/2007, 6:38 AM |
|
In Visual Query Builder under table model, is it possible to have a where condition where you have like '..'. I want my users to enter in there own wildcard characters dynamically and there doesn't seem to be an option for that.
I tried setting the like statement in the expression however it doesn't appear you can use parameters in this section. I tried doing it through sql however it is hard coded so the where statement isn't dropped if no parameter is provided. And, trying to do the custom where statements from this link:
http://docs.codecharge.com/studio3/html/ProgrammingTech...HEREClause.html
Is overly cumbersome to code with the amount of criteria I have since I also have to also start worrying about the recordcount in addition to the custom where. Any help would be appreciated.
Thanks.
Jon
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 10/02/2007, 6:14 PM |
|
jav
What is your environment configuration (versions)??
|
 |
 |
jav
Posts: 8
|
| Posted: 10/04/2007, 11:24 AM |
|
I am using CC 3.1.1.0 with JS on client and VB on the server.
|
 |
 |
|