HnD | using NOT IN, Page 1

using NOT IN

Posts

Gaston
User

Posts: 10
Joined: 24-Jul-2005

# Posted on: 08-Aug-2005 18:34:44

I want to change this: Field IN (SELECT OtherField FROM OtherTable WHERE Foo=2)

into something like Field NOT IN (SELECT OtherField FROM OtherTable WHERE Foo=2)

how can I do that....

Thanks!

Otis
LLBLGen Pro Team

Posts: 39933
Joined: 17-Aug-2003

# Posted on: 08-Aug-2005 18:43:08

Use the overload of the FieldCompareSetPredicate constructor which accepts 'negate' and set that to true

Frans Bouma | Lead developer LLBLGen Pro

Gaston
User

Posts: 10
Joined: 24-Jul-2005

# Posted on: 13-Aug-2005 13:50:57

Thanks!