>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
Hi Paul,
In VFP9 it should be used this way:
CLEAR
CLOSE DATABASES all
DELETE FILE testMacro.d*
CREATE DATABASE testMacro
CREATE TABLE testMacro (f1 I)
APPEND BLANK
APPEND BLANK
pfilter=".T."
CREATE SQL VIEW exampl AS SELECT temp.* from testMacro temp where &?pfilter
?dbgetprop("exampl","View","sql")
USE exampl NODATA
?RECCOUNT()
RETURN
Thanks,
Aleksey.