>Can anybody out there help?
>
>MSDN article Q156631 says quite clearly that the IN() filter condition doesn't work! Thats all very well but how do I do a parameterized view for a numbers of customer IDs when I don't know how many I will need to look for?
>
>Has anybody any good ideas of how to get round this one?
Rather than a p-view with multiple values, create a cursor that contains a record per customer ID, stick the alias of the cursor in the parameter variable, and do something like the following; I've assumed that CustID is the field to match, and it's a C(10) field, and the parameter variable is pvCursorName:
CREATE CURSOR CustNoLst (CustID C(10))
pvCursorName = "CustNoLst"
SELECT * FROM MyCusTbl WHERE CustID IN (SELECT * FROM (?pvCursorName))
>
>Thanks in advance
>Jeremy