Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use of a field name DESC in SQL
Message
De
30/09/2001 12:13:56
 
 
À
30/09/2001 11:07:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00562338
Message ID:
00562340
Vues:
17
>As someone found the logic of VFP when using a field name DESC in a SQL? Sometimes, the same SQL will generate an error if a field name is Desc. Most of the times it'll work.

DESC is a keyword in both VFP-SQL and T-SQL, as in:
SELECT Name, City ;
FROM Customers
ORDER BY Name DESC
so I would avoid it as a field name.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform