Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Designer : SQL Length Limitation?
Message
From
05/09/1996 18:11:55
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
View Designer : SQL Length Limitation?
Miscellaneous
Thread ID:
00007322
Message ID:
00007322
Views:
78
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
Next
Reply
Map
View

Click here to load this message in the networking platform