Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View Designer : SQL Length Limitation?
Message
De
05/09/1996 18:11:55
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
View Designer : SQL Length Limitation?
Divers
Thread ID:
00007322
Message ID:
00007322
Vues:
77
Is there a limitation to the length of a SQL statement that the view designer generates?

With the view designer I created a SQL statement which has
the following where clause:

SELECT ...
WHERE Orders.dueon >= ?ldStartDate;
AND Orders.dueon <= ?ldEndDate;
AND Itmlayer.thickness = ?lcThickness;
AND Itmlayer.color = ?lcColor;
AND Itmlayer.process = ?lcProcess1;
OR (Itmlayer.process = ?lcProcess2);
OR (Itmlayer.process = ?lcProcess3);
OR (Itmlayer.process = ?lcProcess4)

However if I view the SQL it displays:

SELECT ...
WHERE Orders.dueon >= ?ldStartDate;
AND Orders.dueon <= ?ldEndDate;
AND Itmlayer.thickness = ?lcThickness;
AND Itmlayer.color = ?lcColor;
AND Itmlayer.process = ?lcProcess1;
OR (Itmlayer.process = ?lcProcess2);
OR (
and when I run this query it says that I'm missing a ")". I'm not, VFP is the one truncating my SQL!

Also, the way it puts in the parens is not what I wanted.
The desired SQL is:
SELECT ...
WHERE Orders.dueon >= ?ldStartDate;
AND Orders.dueon <= ?ldEndDate;
AND Itmlayer.thickness = ?lcThickness;
AND Itmlayer.color = ?lcColor;
AND ((Itmlayer.process = ?lcProcess1);
OR (Itmlayer.process = ?lcProcess2);
OR (Itmlayer.process = ?lcProcess3);
OR (Itmlayer.process = ?lcProcess4))

How does one do this using the View Designer?

Why doesn't VFP let me modify the SQL directly?

TIA, Kim
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform