Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Syntax Invalid
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00589065
Message ID:
00589256
Views:
32
>>>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
>>
>>Hi Jim.
>>
>>The problem seems to be related to having the catalogue table be the same name as the database. I created a DBC with these two tables and also couldn't get the view to save. I renamed the table to catalog and then it saves just fine.
>>
>>Dan
>
>Dan,
>
>I just created a brand new table with the same structure, but with a totally different name. It still blew up.

What is the name of the new table?

Dan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform