Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index expression for field subsort - descending
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01192125
Message ID:
01192126
Views:
18
Do you really need an index, or would a properly ordered cursor do?

select A,B,C from mytable into myorderedcursor where (any conditions) order by a asc, b desc, c asc

>Hello all,
>
>I have a table with character fields A, B & C
>
>I need to create an index on A (ascending) + B (descending) + C (ascending) to display in a grid:
>
>Apple | Mac | New Hampshire
>Apple | Mac | Washington
>Apple | Granny | New Hampshire
>Apple | Granny | Washington
>Apple | Delicious | New Hampshire
>Apple | Delicious | Washinton
>
>What index expression can I use to accomplish this?
>
>Many thanks,
>
>Ellis
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform