Hello,

in VFP7 and VFP6 this works nicely and is the most powerfull.

CREATE SQL VIEW "VIEW_DYNAMIC" AS ;
SELECT theFields FROM yourTable WHERE &?p_YourWhereClause
(execute in Command Window)

you then can at runtime specify the whole whereclause in the variable p_yourwhereclause

e.g.

USE view_dynamic IN 0 NODATA
p_yourwhereclause = "field1 IN (12,23,34,45,47,46)"
REQUERY('view_dynamic')

the worse thing is that it only works with nonremote views
and in VFP8 it seems to be non workable at all ..

Regards

Christian