Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index expression for field subsort - descending
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01192125
Message ID:
01192126
Vues:
16
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!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform