Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Question about a combo box
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Question about a combo box
Divers
Thread ID:
00745150
Message ID:
00745150
Vues:
57
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform