Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numeric key, combo, vfp3
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00056045
Message ID:
00066701
Views:
37
>>I checked the BoundColumn. I got rid of the ALLTRIM(). I tried using the SELECT in the combo.Init and directly in the combo.Rowsource, in which case combo.Rowsourcetype = 3. I even removed the keyfield from the SELECT and made sure that all SELECTed fields were character. I am still getting the ListID in the combo.Value. Oh, well, I'll just do as Mr. Booth says and use THIS.List(THIS.ListIndex,6). Since this combo won't have a controlsource, I'll have to do something in the combo.GotFocus to make it select the record in the rowsource which matches the record for that row of the grid. I should probably make the column with the combo have width 0 when not in "edit mode", and make it display something other than a field value when in edit mode, but not selected. What a pain. It almost seems easier to rip up my keys and make them characters.
>
>
>Bret, I started up VFP3, made a combo from all 3 numeric fields from a table and ran it.
>
>Rowsource:
>select str(amtdue,8) as amt, str(discount,5) as disco, str(tax,5) as ctax from defaults into cursor atemp
>
>RowSourceType: 3
>
>No problem. I changed the bound column and checked the value with debug and they were all character, and the correct value.
>
>Maybe this will help.....
>
>Barbara

it'll help me. i've been working w/ a novice programmer who noticed this. i hadn't run into it before because i don't use numeric fields in combos, but he was trying to and ran into this.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform