Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use of a field name DESC in SQL
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00562338
Message ID:
00562344
Vues:
16
>select * from t order by t.desc
>
>should *always* succeed. I have more than once used reserved VFP keywords as field-names and VFP sometimes complains, but not if the name is qualified.

I still prefer to avoid the headache. I use 'DESCRIP' for 'DESC'.

the following, from your example, strikes me as funny looking, so I wouldn't do it myself.
select * from t order by t.desc desc


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