>>We have worked in previous VFP versions with macro sustitution in parametrized views as:
>>create sql view ... as select ... where &?mycondition ...
>>This is not working on VFP 8. Have we losed it forever?

>Try it without the question mark

>create sql view ... as select ... where &mycondition

That isn't the point, Alex: if he does it that way, he creates the view statically. If he includes the parameter marker, he can substitute the condition at runtime.