Doru,

what can I do for you? You solved my bigest problem with VFP8.0. I never come to the idea to have the Var not in scope. I was starting to translate all to Cursoradapter where a can ad the &Where into the string. But it was a to much work so I left those applications alone ...

Thank you very much

Agnes
>>>>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'