Hi All,
today I run in a new proble with VFP 8.0
In older versions I use a syntax like
lcRequery = ''
CREATE VIEW myView as SELECT;
Cur1.SomeField;
FROM aTable AS Cur1;
&?lcRequery
USE myView
lcRequery = 'INNER JOIN SomeotherTable ON .. Where ... Group'
REQUery
The
&? statement delays the macro expansion to the USE or REQUERY.
This creates high flexible views.
Under VFP 8.0 this produces ERROR 36 no matter which Setting of SET ENGINEBEHAVIOR is used.
Is there some reason on this change? Is it somewhere listed? What can I do to get around that problem?
This is a big deal because I have some projects where I us a lot of this ...
TIA
Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]