Tables: Company and Contact
Form: Contact Entry Form
Goal: Provide end-user with a drop-down of Companies entered into the Company Table.
After making the Field a COMBOBOX, and the ValueList drop-down began to work, I only received only 502 of the 1602 Companies in the Company table. Is this a bug or is there a limitation to the amount of records a drop-down list can have?
All the best,
Dean
DeanEBedford:
Tables: Company and ContactForm: Contact Entry Form
Goal: Provide end-user with a drop-down of Companies entered into the Company Table.
After making the Field a COMBOBOX, and the ValueList drop-down began to work, I only received only 502 of the 1602 Companies in the Company table. Is this a bug or is there a limitation to the amount of records a drop-down list can have?
All the best,
Dean
I submitted a solution having the same problem to the dev team a week ago. They told me the bug will be corrected very soon.
Servoy release 1.2 rc6 has a dbvaluelist limit of 500 items … for more items we suggest to use a formDialog instead of valuelist on combobox due to performance.
We are seeing the very same combo box limit in versions 2.2.2 and 2.2.3.
Is there a projection when we might see a version without this limitation?
Do users really want to scroll through 500+ items on a Combo-box? I would have thought this was more a GUI issue than ComboBox limitation.
Jan’s suggestion of putting a list/table on FID would enable the data to be presented in more intuitive format - the list could then be filtered with A…Z buttons or whatever is appropriate to speed selection. IMHO
Graham Greensall
Worxinfo Ltd
Do users really want to scroll through 500+ items on a Combo-box? I would have thought this was more a GUI issue than ComboBox limitation.
You know, you’re absolutely correct.
But, one thing is important here - if Dan has a requirement to deliver a combo box entry component, then that’s what he must do. So, from that perspective, his request is a valid one.
I accept that it may be a valid request - but feel that sometimes clients need to be ‘educated’ on the range of presentational options that we have with Servoy. The chance of a User mis-selecting from a 500+ item list is much higher than if the data is filtered and presented in a sortable table.
People do get into a comfort zone with existing software and put up with all sorts of limitations just because they’ve got used to it. We have a chance to help them ‘see the light’
Regards
Graham Greensall
Worxinfo Ltd
I just created a quick & dirty form (v3.1), with combo boxes, and sure could have used a higher limit. One value list has about 1500 values
Can anyone point me to an example of some work-arounds? just for ideas, e.g. form in dialog, etc
thanks
greg
PS
I just tried a text field, with value list attached. This appears to work, filtering the drop list as you type, but double click to select is clumsy