Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Drop-down list and alpha order
Message
De
07/07/1999 17:07:31
 
 
À
07/07/1999 16:59:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00238533
Message ID:
00238540
Vues:
16
>I’m populating the display values of a drop-down list from a cursor.
>
>THISFORM.CodeFrame.SponsorPage.SponCatCbo.RowSource=""
>SELECT nSpCatKey,cSpCatName FROM SponCategory ORDER BY cSpCatName
>THISFORM.CodeFrame.SponsorPage.SponCatCbo.RowSource="Q_SponCat.cSpCatName"
>
>.... I understand why it’s doing this but I don’t know how I can display the values in alpha order and still display the right value. I’ve tried setting BoundTo=.t. but then the field is empty.

For alphabetical order try
SELECT cSpCatName, ;
    nSpCatKey, ;
    lower(cSpCatName);
    FROM SponCategory;
    ORDER BY 3
Then Bound your Combo to Column 2

This will display your character field to your users and save the numeric key in your table. HTH
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform