1. Home
  2. LLBLGen Pro
  3. LLBLGen Pro Runtime Framework

FieldCompareNullPredicate

Posts   
 
    
shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 05-Jul-2011 08:56:45   

LLBLgen 3.1 release 1st July MSORACLE (oracle 9i/10g) .NET framework 2.0

bucket.PredicateExpression.Add(new FieldCompareNullPredicate(OrderFields.OrderDate, null));

In this example, how do i check for NOT NULL instead of null ?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 05-Jul-2011 11:14:30   

There is an overload of the CTor that accepts a boolean arameter (negate), set it to true to produce "NOT NULL"

bucket.PredicateExpression.Add(new FieldCompareNullPredicate(OrderFields.OrderDate, null, true));
shekar
User
Posts: 327
Joined: 26-Mar-2010
# Posted on: 05-Jul-2011 11:22:33   

Walaa wrote:

There is an overload of the CTor that accepts a boolean arameter (negate), set it to true to produce "NOT NULL"

bucket.PredicateExpression.Add(new FieldCompareNullPredicate(OrderFields.OrderDate, null, true));

Thanks Walaa