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