Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Drop-down list and alpha order
Message
From
07/07/1999 17:07:31
 
 
To
07/07/1999 16:59:20
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00238533
Message ID:
00238540
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform