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