General information
Category:
Visual FoxPro Beta
Title:
SQL, Views, and Macro Substitution
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only