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 !