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... :(