>Has anyone been able to get the IN clause to work with a view parameter? In the view designer filter if I have ctype IN C,D then it will correcly bring up all records with a ctype of either a C or a D. However, if I put ctype IN ?vp_ctype and run the query and put C,D in the view parameter I only get records with a C in the ctype (or if I put D first I get only records with a D in ctype).
>
>I need to be able use a view parameter to pull records that match a comma delimited list...anyone?
>
>Thanks!
If this is a VFP table, then you can use
lcTypeList = "C,D"
and
CREATE SQL VIEW myView AS;
SELE * FROM MyTable;
WHERE ALLTRIM(cType)$?lcTypeList
Erik Moore
Clientelligence