>>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))
>*
>*  Insert a record per CustID to include into the cursor CustNoLst
>*
>pvCursorName = "CustNoLst"
*
*  NB - do the following:
*
USE MyPView
*
*  And this is the basis of the view creation:
*
CREATE SQL VIEW MyPView AS ;
  SELECT * FROM MyCusTbl WHERE CustID IN (SELECT * FROM (?pvCursorName))

>
>>
>>Thanks in advance
>>Jeremy