Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field naming conventions in SQL
Message
De
12/12/2000 17:06:23
 
 
À
11/12/2000 11:43:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00450333
Message ID:
00452582
Vues:
27
Hi Doug,

>First, you can get around the problem of using reserved words by putting quotes around them; for example, SELECT "PERCENT" FROM SOMETABLE.

Does this work for all back-ends ?

Also, you would have to put quotes around every field name in order to be safe - PERCENT was not a reserved word in SQL Server 6.5, but it was one in SQL Server 7.0 and above.

Code you write now could easily be broken when the user upgrades his copy of the back-end.

Best.

Matt.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform