valuelist with empty entry

Classic Servoy
1

I have a valuelist which is based on: all values of a specific row in a table.

there are a few emtpy records (which can not be deleted)

Is there a possiblity to have a feature in: Define Valuelist
which says: do not show empty values.

Is this possible?

2

If you use a SetValueListByQuery method to fill the Value list, you can use as query:

select field from table where field is not null

(fidle around with the syntax a bit)

I think this could solve your problem.

Paul

ps: the method should be attached to either OnLoad or OnShow, depending is the list of values can change…

3

I my case, that is not possible, because the list must contain data of a table row, which can be changed anytime.

So I would like this as an standard feature.