Geoff,

please be that kind to start a new thread instead to reanimate an old one. You can create the new thread in a way that a certain UT member will be noticed.

As far as I remember VFP 7.0 ::), the syntax must be (Version before VFP 8.0):

lcMacro = '' &&Try if neeeded
CREATE SQL VIEW V_test AS SELECT * FROM ulog &?lcMacro

HTH

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