Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data binding to a numeric fld in a comboBox
Message
De
23/06/2005 22:51:14
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Data binding to a numeric fld in a comboBox
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000
Network:
Novell 6.x
Database:
Visual FoxPro
Divers
Thread ID:
01026143
Message ID:
01026143
Vues:
68
greetings all

I am using a comboBox to select a shop order from a table=shopOrders. shopOrder defined as numeric 6. It is binding to poMast.shopOrder numeric 6.
The Problem: When I select an item, the combo returns the listIndex, not the shop order. If I remove the controlSource, I get the value of the shopOrder, not the listIndex which is the desired outcome. When I browse the cursor, the sql statement does return the shopOrder
SELECT s.shopOrder, s.custCode, c.name;
       FROM shopOrders as s;
       INNER JOIN custMast as c ON s.custCode = c.Code;
       ORDER BY s.shopOrder;
       INTO CURSOR tmpCurShopOrders
WITH thisform.clsdatadesc.cboShopOrder
     *** only flds that need populated if using framework and clsCboBox
     .displayValue = "tmpCurShopOrders.shopOrder"
     .controlSource = "poMast.shopOrder"
     .RowSourceType = 2  && alias
     .rowsource = "tmpCurShopOrders.shopOrder, custCode, name" 
     .columncount = 3
     .columnWidths = "50,50,150"
     .style = 2
     .boundcolumn = 1  && listValue
     .listindex = 1
ENDWITH
Any ideas??
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform