Hi

CREATE SQL VIEW V_test AS SELECT * FROM ulog &lcMacro

I can do this in VFP 8 but not in VFP 7.
I get a "Command contains unrecognised phrase/keyword"

Am I doing something wrong??

Regards
Geoff


>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,