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
If everything seems to be going well, you obviously don't know what the hell is going on !