Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Syntax Invalid
Message
From
04/12/2001 09:50:04
Jonathan Cochran
Alion Science and Technology
Maryland, United States
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00589065
Message ID:
00589265
Views:
20
This message has been marked as the solution to the initial question of the thread.
Renaming the "Selections" table seems to make the error go away. I first tried to rename it to "xyz", and that worked. Then, I renamed it to "Selectionz", but that failed. I then renamed it to "Celections", which worked. Maybe FoxPro is seeing the first few characters of the table name, and interpreting it as a SELECT statement?

>Can anybody tell me why this is invalid? I can run it, I just can't save it.
>
>
>SELECT Selections.*, Catalogue.cproduct;
> FROM  catalogue!catalogue INNER JOIN catalogue!selections ;
>   ON  Catalogue.iid = Selections.iproductid
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform