Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data binding to a numeric fld in a comboBox
Message
 
 
To
23/06/2005 22:51:14
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01026143
Message ID:
01026144
Views:
22
This message has been marked as the solution to the initial question of the thread.
Set BoundTo property to .T.
>
>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??
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform