Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index on Month
Message
De
17/08/1998 07:26:49
Rex Mahel
Realm Software, Llc
Ohio, États-Unis
 
 
À
14/08/1998 16:15:39
Zaraq Bari
Bari Studios Limited
Lahore, Pakistan
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00127022
Message ID:
00127338
Vues:
39
Zaraq,

How about:

INDEX ON ;
IIF(MONTH = "JAN",1,;
IIF(MONTH ="FEB",2,;
IIF(MONTH="MAR",3,;
IIF(MONTH="APR",4,;
IIF(MONTH="MAY",5,;
IIF(MONTH="JUN",6,;
IIF(MONTH="JUL",7,;
IIF(MONTH="AUG",8,;
IIF(MONTH="SEP",9,;
IIF(MONTH="OCT",10,;
IIF(MONTH="NOV",11,;
IIF(MONTH="DEC",12,0)))))))))))) TAG WHATEVER

HTH

Rex

>I have set a character field named Month with a regular index to store name of the months.When I use SET ORDER TO MONTH it indexes the field Month alphabetically as it is supposed to.How can I make it index on January , Feburary , March and so on instead of April, August, December etc....
>Thank You All
>Zaraq Bari
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform