Trouble with IN clause again

Posts   
 
    
tprohas
User
Posts: 257
Joined: 23-Mar-2004
# Posted on: 06-Sep-2006 00:08:04   

I'm need to create a custom string to use with an IN clause so I can create a query like the following.

SELECT
    *
FROM
    dbo.Cassette C
INNER JOIN
    dbo.ProductVersion PV ON C.ProductVersionID = PV.ProductVersionID
INNER JOIN
    dbo.Product P ON C.CassetteID = P.ProductID
WHERE
    (StyleCode = 'R' OR StyleCode = 'B')
AND
    Religion IN ('G','S','B')

Why is there no way to do this using the LLBLGen predicates? It seems that I can only use another field/column as the value for the IN. This is the second time I've run across this problem and am wondering if there are any plans to allow this soon?

psandler
User
Posts: 540
Joined: 22-Feb-2005
# Posted on: 06-Sep-2006 00:22:15   

Have you looked at the FieldCompareRangePredicate?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 06-Sep-2006 07:26:48   

Indeed it has been always available through FieldCompareRangePredicate,

Please refer to the LLBLGen Pro manual "Using the generated code -> Adapter/SelfServicing -> Filtering and sorting -> The predicate system"

tprohas
User
Posts: 257
Joined: 23-Mar-2004
# Posted on: 07-Sep-2006 20:33:42   

Thank you, I missed seeing this before.