Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use of a field name DESC in SQL
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00562338
Message ID:
00562345
Views:
24
>>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
>
Neither would I - desc is usually a memo field :-) !!
Previous
Reply
Map
View

Click here to load this message in the networking platform