Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo in grid doesn't show value
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01519540
Message ID:
01519586
Views:
30
>>>>>Anyway, the last column's problem still remains.
>>>>
>>>>Here it is one example form.
>>>>It is NOT a bug free form :-))
>>>>Just wanted to show combos in grid.
>>>
>>>I see, interesting - I'll try similar idea with BackColor.
>>>
>>>One difference in the last column - originally it doesn't fit, so I need to resize the form to see it. Also, the field stores S, E, C and I want to show description (so, the combo consists of 2 columns). Can you please revise the sample taking into account these two things?
>>>
>>>Thanks in advance.
>>
>>
>>Naomi,
>>
>>I suppose if you change the code in the init to
>>
>>With Thisform.Grid1.Column4.Combo1
>>*.AddItem("Start Seat - S")
>>*.AddItem("Center Seat - C")
>>*.AddItem("End Seat - E")
>>
>>	.AddListItem( 'S' )
>>	.AddListItem( 'Start Seat', .NewItemId, 1 )
>>	.AddListItem( 'C', .NewItemId, 2 )
>>	.AddListItem( 'Centre Seat' )
>>	.AddListItem( 'E', .NewItemId, 3 )
>>	.AddListItem( 'End Seat')
>>
>>Endwith
>>
>>Thisform.Grid1.SetAll("DynamicBackColor", "thisform.RefreshCombo()", "Column")
>>
>>
>>
>>
>>you can enjoy a good night rest?
>>
>>Regards,
>>
>>Koen
>
>It's 9:40 am now :) I actually have already slightly different code for the last combo:
>
>
>CREATE CURSOR csrSeatsCentricity (Descrip C(20), CenterMost C(1))
>INSERT INTO csrSeatsCentricity VALUES ('Start Seat','S')
>INSERT INTO csrSeatsCentricity VALUES ('Center Seat','C')
>INSERT INTO csrSeatsCentricity VALUES ('End Seat','E')
>
>
>and I have set RowSourceType to 3 and RowSource to select * from csrSeatsCentricity into cursor csrDump nofilter in the property sheet and in my form this didn't work.
>
>I'll try it now with the test from from Boris.
>
>UPDATE. It did work correctly for Boris case, I'll try more experiments with mine.


Here it is with SQL Statement row source.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform