Hi sergey,

>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

I don't understand why this is this way.
- In VFP7 both strategies work (&cWhere and &?cWhere)
- In VFP8 only &cWhere works
- In VFP9 only &?cWhere weems to work

I'd say this is a bug in an attempt to fix something reported in Yet another BUG: Macros in view definition not supported Thread #753139 Message #753139

Walter,