Hi gunter,

Well, it was only needed to explicitly tell VFP that it must evaluate the cWhere during requering the view at runtime.

If you did not include the ? and and variable cWhere does exist during creation of the view, it would just evaluate the cwhere at creation time (which of course leads to a fixed where definition), while we want one where cWhere is evaluated at design time.

Now in VFP9, it seems that you cannot omit the ? in the view definition, hence my comments.

Walter,




>
>>>It seems that omitting the ? in VFP9 is not supported. Don't ask me why. I'm as stumped as you are.
>
>Walter,
>
>>>>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
>><<