Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with CREATE VIEW
Message
De
15/05/2003 08:03:38
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Problem with CREATE VIEW
Divers
Thread ID:
00788612
Message ID:
00788612
Vues:
46
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]
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform