Hi

I'm using selfservicing model and VS 2003, I'm trying to create a predicate expression that generates a query like this:

FALSE OR (STATE_FIELD='0') OR (STATE_FIELD='1').....OR (STATE_FIELD='X')....

So, I create a predicate expression instance and use AddWithOr method ... ... but I'm not able to generate the first part of the sql query ( a simply ... FALSE ).

Thanks

Matteo

You can implement IExpression as shown in the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3829

But as far as I know, you can do without the FALSE OR expression. Since FALSE would have no effect on the result of the OR operation. The result will be totally dependant on the other predicates.

FALSE OR XYZ = XYZ

Walaa wrote:

You can implement IExpression as shown in the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3829

Ok thanks I'll try it

Walaa wrote:

But as far as I know, you can do without the FALSE OR expression. Since FALSE would have no effect on the result of the OR operation. The result will be totally dependant on the other predicates. FALSE OR XYZ = XYZ

The predicate FALSE is always present while the other depends of some option checked on the UI .... If no option is selected I've to return FALSE...

Thanks for the suggestion