Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Syntax Invalid
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00589065
Message ID:
00589256
Vues:
33
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform