Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query Parse Error?
Message
From
30/10/2002 13:15:34
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Query Parse Error?
Miscellaneous
Thread ID:
00717003
Message ID:
00717003
Views:
65
When I try to create a query in the designer I get an error when I try to save the query.

The query runs fine, but it wont let me save it:

"query parse error-try rebuilding in query wizard or by using view designer join tab"

It always happen when I add the fourth table.

SELECT Tproduct.fpname, Ttooltype.fttype, Tvendor.fvname;
FROM dbtwiz!tproduct INNER JOIN dbtwiz!ttool;
INNER JOIN dbtwiz!ttooltype;
INNER JOIN dbtwiz!tvendor ;
ON Tvendor.fvnum = Ttool.fvnum ;
ON Ttooltype.ftnum = Ttool.ftnum ;
ON Tproduct.fpnum = Ttool.fpnum
Next
Reply
Map
View

Click here to load this message in the networking platform