Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ComboBox returns Index Number
Message
De
31/05/1999 04:33:19
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
ComboBox returns Index Number
Divers
Thread ID:
00224614
Message ID:
00224614
Vues:
70
Does VFP 6 combo box returns the index number instead of the
field value for datatypes: Integer and Numeric?

Case in point:
1. CustOrder.ID in CustOrder relates to CUSTMaster.ID in CUSTMaster
2. ComboBox1.RowSourceType ="3-SQL Statement"
3. ComboBox1.RowSource = Select CUSTMaster.Name, CUSTMaster.ID from
CUSTMaster order by CUSTMaster.Name into cursor cCUSTMaster
4. ComboBox1.BoundColumn =2
5. ComboBox1.ControlSource =CustOrder.ID

A. If the ID data type is character, ComboBox1 returns the
actual ID data of the CUSTMaster table which is "00001"
ex: CUSTMaster.ID ="00001" .Name ="DEF"

B. If the ID data type is numeric, ComboBox1 returns the index
number of the item in the combolist. In the list "ABC" is
shown first and the index is 2. ComboBox1 returns 2 if "ABC"
is clicked
ex: CUSTMaster.ID =2 .Name ="ABC", .ListIndex =1
CUSTMaster.ID =1 .Name ="DEF" .ListIndex =2


Anybody, please confirm if this is the case.

Thanks, Ramil Alcano 5/31
ramil
~~ learning to stand still
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform