Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data binding to a numeric fld in a comboBox
Message
From
23/06/2005 22:51:14
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Data binding to a numeric fld in a comboBox
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01026143
Message ID:
01026143
Views:
67
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??
Next
Reply
Map
View

Click here to load this message in the networking platform