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