Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question about a combo box
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Question about a combo box
Miscellaneous
Thread ID:
00745150
Message ID:
00745150
Views:
56
I am building a combo box with state code and state name,
I am forcing "all states" into the array,
I would like for "All States" to be first in the list with all the other states alphabetically without placing a space as the first character.

Below is my select statement which works fine:(but i'm forced to put a space in for it to be first)

select sccdesc as col1, scccode ;
from choice where scctype = "STATENUM";
into array thisform.lastates;
union select " All States" as col1, " " as scccode;
from choice order by col1

this.rowsource = "thisform.lastates"

thank you in advance
Carl <><
For God so loved the world that he gave his one and only Son, that whoever believes in him shall not perish but have eternal life. John 3:16
Next
Reply
Map
View

Click here to load this message in the networking platform