Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with CREATE VIEW
Message
From
15/05/2003 08:03:38
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Problem with CREATE VIEW
Miscellaneous
Thread ID:
00788612
Message ID:
00788612
Views:
48
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' && and So On

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.

Off

There is no place like [::1]
Next
Reply
Map
View

Click here to load this message in the networking platform