HI geoff,

Unfortunately it is not supported. IMO, something that the VFP team needs to address as it really is a cool feature.

Walter,


>Hi Sergey
>
>I know this works with local views but it was my understanding that it would work with remote views also. Unfortunately, when I try to create the remote view I get a syntax error.
>
>Is it not supported with remote views or do I have to do it differently?
>
>regards
>Geoff Scott
>
>>Doru,
>>
>>It still works in VFP9 but you have to code it differently:
>>
>>- The variable lcMacrotest has to be defined before view is created
>>- The variable lcMacrotest should be precceded by '?' in the view
>>

create sql view lvMacrotest as sele * from macrotest where &?lcMacrotest

>>
>>>The following worked in VFP 8, but it does not work in VFP 9
>>>

create table macrotest free (f1 c(10), f2 c(10))
>>>create database dbmacrotest
>>>create sql view lvMacrotest as sele * from macrotest where &lcMacrotest

>>>This was not documented, but it was nice. Macro was stored in the view expression as macro, and when the macro expression in scope changed, requery() expanded it.
>>>Too bad... :(