>Hi John,
>
>Hi finally resolved the problem by using SPT:
>
>lcHld_Cat1 = "'F', 'G', 'H'": Passed from user interface
>
>lcSQL = "Select * From DOCKET, Office_Docket, Docket_Org, Organization"
>lcSQL = lcSQL+" WHERE DOCKET.DOCKET_ID=Office_Docket.DOCKET_FK"
>lcSQL = lcSQL+" AND DOCKET.DOCKET_ID=DOCket_ORG.DOCKET_FK"
>lcSQL = lcSQL+" AND ORGANIZation.ORG_ID = DOCket_ORG.ORG_FK"
>lcSQL = lcSQL+" AND SUBSTRING(PROD_CAT_CD,1,1) IN (&lcHld_Cat1)"
>gnHandle=sqlconnect("xxxxxx", "yyyyy", "??????")
>=SQLExec(gnHandle, lcSQL, "vReports")
>

Yep, that way always worked. It's the parameterized view that doesn't unless you use a subquery. But then you have to populate a cursor or table with the values you need.

...where ... and State in (select state from some dummied_up_table)