valuelist behaviour in webclient differs from smart client

Classic Servoy
1

Hi,

I have a field on a form (table view) that has a valuelist attached to it.
It is a classic id,name list, that is build from a query(setValueListItems)
The name is shown and the id is stored.

The difference is with null values.
The smart client shows an empty field if no id is stored.
Thats correct.

The webclient will show the first name value of the valuelist.
Thats not correct, it should also show an empty filed.

Servoy Developer
Version 3.1.5-build 409
Java version 1.5.0_11-b03 (Windows XP)

2

Have you tried to explicitly add a null value to your value list? I could image that th web client always selects a value from a combobox.

3

Hello Patrick,

Thanks for your reply.

Tried that, does not make a difference.

tried both :

  • union select ‘-’ naam,0 contact_id

and

  • union select ‘-’ naam,null contact_id
4

Maybe thirdly?:

union select '' naam, null contact_id
5

Some more info :

The (existing) table.column for which the valuelists is implemented has a lot of null values.

When i set “Allow empty values” in the Valuelist both the SmartClient and the WebClient give the correct results.

When i do not set “Allow empty values” in the Valuelist the SmartClient stilll gives the correct result, but the WebClient shows the first value in the valuelist for all column null-values.

Setting the “Allow empty values” works for me, or i could give all the null values a “default value” and then it would also work.

Hans