Walter,

I was following your thread #753139. I'm not clear if the solution to the problem comes out of that thread. At least I didn't understand until today.

The solution is

CREATE SQL VIEW Tralala AS SELECT * FROM somwhere &lcMacro

without the &? thing.

lcMacro must not be in scope in the moment of view declaration. I've changed all my views this moment, it runs perfectly in VFP 8.0 as well as in VFP 7.0


Agnes

>Carlos,
>
>
>see Yet another BUG: Marcos in view definition not supported Thread #753139 Message #753139
>
>>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?
>
>Walter,