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 #
753139Walter,