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