Combobox and empty values

Classic Servoy
1

Hello,

In our solution, we use lots of custom valuelists displaying i18n values related to an integer dataprovider, like this one.
i18n:GLS.VL.rResourceTitle.Mrs|1
i18n:GLS.VL.rResourceTitle.Miss|2
i18n:GLS.VL.rResourceTitle.Mr|3
i18n:GLS.VL.rResourceTitle.HH|4

i18n:GLS.VL.rResourceTitle.Other|9999
First, when setting the valuelist to accept empty values, the combobox displays an 'empty’line at top, but does NOT save nor ‘null’ nor ‘empty’ into corresponding dataprovider.

Second, the ‘dash’ (see above) is correctly displayed as a separation line, but can be selected, thus letting us return ‘null’ to the corresponding dataprovider even if we do not allow empty values for this list :!:
I suggest that you disable the separation line unless the user associate a value to it by putting a ‘|’ …

Third, when the dataprovider is of type ‘Integer’ in sybase, comboboxes display corresponding i18n values when showing and browsing records. This do not work when we try to associate a dataprovider of type ‘LongInt’, is this intentionnal?

2

1> I can’t reproduce it. It will set a empty value in it (i changed the implementation that it will add a null to the return value for the empty.
What is in youre eyes selected? What does it select? The previous value?

2> I can’t disable it. It is just a entry in the list that is displayed a specific way. What i could do if you select it then the next item (or previous item if there is no next) will be auto selected.

3>I have to test where longint would be mapped at. What do youe see for type in the dataprovider dialog of servoy?

3

Hello Johan,

What is in youre eyes selected?

If the dataprovider already contains a value, when I first click on the ‘empty’ line, the combobox keeps open as if it ‘refused’ the click. Clicking a second time closes the combobox, showing an empty but ‘active/selected’ combobox field. At that point, if I retry to select the empty line, combobox list behaves ‘naturally’ at the first click.
In the end, the display is an empty field…

What does it select? The previous value?

Here is the point, at that moment, my combobox field displays exactly what I want (‘empty’), but if I leave that particular record (by any means) and return to it, it dispays the previous (non empty) set value! Thus confirming that ‘empty’ or ‘null’ was not sent to dataprovider (which of course is set to accept ‘null’).

I can’t disable it. […] What i could do if you select it then the next item (or previous item if there is no next) will be auto selected.

At least, this would prevent entering a non allowed empty value, may be this should be notified somewhere in the future docs.

What do you see for type in the dataprovider dialog of servoy?

Sybase Anywhere type: bigint, unsigned bigint
Both show as INTEGER in Servoy

For standardization purposes, we decided first to only use bigint and unsigned bigint in our new solutions as it delivers more ‘horsepower’ for primary keys, as the 4 byte overhead is not more an issue in today databases.

Once again, I thank you for your support.

4

can you send me a test solution with those big-int and combo deselect problems? (with some small sample data if possible)