General information
Category:
Forms & Form designer
>>I’m populating the display values of a drop-down list from a cursor.
>>
>>THISFORM.CodeFrame.SponsorPage.SponCatCbo.RowSource=""
>>SELECT nSpCatKey,cSpCatName FROM SponCategory ORDER BY cSpCatName
>>THISFORM.CodeFrame.SponsorPage.SponCatCbo.RowSource="Q_SponCat.cSpCatName"
>>
>>When the form is displayed the value in SponCatCbo is wrong, if I order by nSpCatKey it’s right. I understand why it’s doing this but I don’t know how I can display the values in alpha order and still display the right value. I’ve tried setting BoundTo=.t. but then the field is empty.
>>
>>Any help on this would be appreciated.
>>
>>/Chris
>
>The information you supplied is not complete, so I will guess. It seem to me that you pick-up two fields (Integer and Character) and want to bind your combo on integer, showing ordered Characters in the list portion. You may accomplish these by following settings:
>.Rowsourcetype=6
>.Rowsource="mycursor.charfield,intfield"
>.BoundTo=.T. && it's necessary for bound combos only
>.BoundColumn=2
>When you create a cursor, order it by character field.
Edward - Thank you. It now works as it should, I was missing the BoundColumn.
/Chris
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only