Wow ¡¡ Thanks Doru. It wasn't easy to think in this option.
>>
>>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.
>
>Actually, if mycondition variable is not in scope at the time of the view creation, the view is
not static. The macro will expand at execution time, so it will act like a parameterized view, i.e.
>
>mycondition = [title = 'ABC']
>use mydbc!myview
>* all recs with title='ABC'
>
>mycondition = [author = 'XYZ']
>requery()
>* all recs with title='ABC'
Saludos,
A.G.P.
---------