I am getting an error in the VFP 9.0 Beta when opening a View (at runtime) that is defined by SQL that includes macro substitution like the following:
select * FROM ji!job WHERE &vcWhere

It doesn't matter whether the variable "vcWhere" is defined or not, I still get a "Syntax Error". If I change the SQL to this:
select * FROM ji!job WHERE (vcWhere)

the Query Designer seems to handle this OK (providing the variable "vcWhere" is at least defined using the command window).

I'm wondering if anybody else has run into this and if there is another/better solution?

Thanks,
Paul James