>Hi,
>
>I want to create a remote view ( SQL Anywhere database) with the view designer of VFP 9.0 that retrieves the items of all the bills of which the ids are contained in an IN (.. ) condition.
>
>
>The non parameterized statement is something like SELECT * FROM Salesitems WHERE isalesdocid IN (1,2,3) and it retrieves correctly all the records.
>
>When I try to create a parameterized remote view version of this, I enter in the View Designer the filter condition: isalesdocid = IN ( ?vp_isalesdocid). The designer accepts this and when I look at the Designer's SQL window I see:
>
>SELECT * FROM Salesitems WHERE isalesdocid IN (( ?vp_isalesdocid ))
>
>When I browse this view, and I fill in 1,2,3 or “1”,”2”,”3” in the View parameter popup window, I only get the items that correspond to the first ID value (1)
>
>Can someone help me with retrieving all the records corresponding to the IN() condition?
>Thanks in advance,
>
>
>Mark

try with a macro

in (&vp_isalesdocid)