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... :(
May all your weeds be wildflowers