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:
00056452
Views:
42
>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
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform