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.