>When I try it (VFP9):
>
>CREATE SQL VIEW TEST REMOTE AS SELECT * FROM VWBILLREPORT WHERE isalesdocid IN (&inItems) CONNECTION 3PConnect
>
>I get:
>
>Connectivity error: [Sybase][ODBC Driver][Adaptive Server Anywhere]Syntax error near '&' on line 1
>
>Mark
>
>
>It works for me.
>
>PUBLIC inItems
>inItems = '1,2'
>CREATE SQL VIEW TEST REMOTE AS SELECT * FROM TABLE WHERE id IN (&inItems) CONNECTION ....
>USE TEST

Sorry I had forgotten it, VFP have a bug here:
if inItems exists it replace the &inItems into the defined view,
otherwise it leave the &inItems as it is.

Use a CursorAdapter.