General information
Category:
Forms & Form designer
>>>>>>>>I have a combobox on a form working fine with rowsourcetype = 1 and rowSource as 1 to 6.
>>>>>>>>
>>>>>>>>Now I get a requirement to change the row source to 1 to 120.
>>>>>>>>
>>>>>>>>So, I created a cursor with 1 integer field and populate it. change rowSourceType to 6 and rowSource to the cursor name.
>>>>>>>>
>>>>>>>>The comboBox populating fine but I can not select anything from it.
>>>>>>>>The combobox is bound to a integer column in the database.
>>>>>>>>
>>>>>>>>I am not sure if this is a bug in V9 or I am doing something wrong.
>>>>>>>
>>>>>>>Your RowSourceType should be set to alias, not fields in this case.
>>>>>>
>>>>>>I tried all the combination except array. the same problem.
>>>>>>There is no code in the combobox.
>>>>>
>>>>>Check BoundTo property of this combobox.
>>>>
>>>>I don't think BoundTo will cause this but I tried it .F. and .T. the same problem.
>>>>
>>>>This is weird and I am sure i am doing something stupid here but can't see it
>>>
>>>Set its value to 0 in Properties Window.
>>
>>I just transformed the integer to character and it is working fine.
>>I did select ALLT(STR(valuefield))
>>
>>So we can not use integer as a source for combobox?
>
>
>Sure you can, but for this you should tell the Combo that you want to have its value as a numeric.
>Just set Value Property to 0 (zero) and it will convert all for you.
>Remember, ALL LIST() values are CHAR() no matter how you store them. You can't use any other type than char with ADDITEM() or ADDLISTITENM().
Setting the value to 0 did not fix the problem.
Again, it populates fine but could not select a value.
Previous
Next
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