>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?
One way to do this is to build a list of the IDs in a cursor or table. Then do the view with a nested query or join (you can't do this in the vfp view designer, of course, though - but that's no real obstacle - use eView instead.)
Your view might look for example like:
CREATE SQL VIEW "myview" ;
AS SELECT * FROM mytable ;
where mytable.cid in (select temp.cid from temp)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.