Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql with group by problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00034676
Message ID:
00036365
Views:
34
>> I apologize for not replying sooner, I have been on travel to Washington
>> D.C. the past week. DESC would probably be fine to use as a field name in
>> a table. Just be aware that there is a VFP function - DESCending() - that
>> returns a logical value indicating if an index was created as descending.
>
>N N OOO !!
>NN N O O !!
>N N N O O !!
>N NN O O
>N N OOO !!
>
>Do Not Ever Use DESC As A Field Name. You will _never_ be able to issue
>a SELECT -- SQL to information.
>
>/Paul

Actually, Paul, you CAN if you include the table name: mytable.desc

I've needed to do this when using a couple of pre-designed tables, and it worked fine. Makes me nervous, though.

Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform