FieldCompareSetPredicate with NOT EXISTS

Posts   
 
    
YvesVD
User
Posts: 177
Joined: 19-Oct-2006
# Posted on: 10-Sep-2008 13:53:03   

Hello,

I need to create a predicate that generates the following Where clause (ORACLE) : WHERE NOT EXISTS (SELECT 1 FROM CUSTOMER WHERE STATUS = 'OK') I tried with this predicate FieldCompareSetPredicate but it accepts only SetOperator.EXISTS but not the NOT EXISTS. Any suggestions is welcom.

Thanks.

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 10-Sep-2008 16:40:30   

It also has an overload that accepts a negate parameter.