Information générale
Titre:
View Designer : SQL Length Limitation?
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement