>
>try with a macro
>
>in (&vp_isalesdocid)
>
>>
>Thank you Fabio for your suggestion but the backend SQL Server doesn't understand the macro substitution syntax & so this doesn't work.
>I don't really know why VFP only takes into account the first value in the IN( x,y,z) clause so I think I'll settle for a SQL Pass Through approach because this does work.
>
>BTW: I also tested manually creating the remote view but this gives me the same result as the VFP9 View designer.
>
>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