Value List Value

Classic Servoy
1

I am trying to create a value list that will return a code instead of the value that is displayed. I can accomplish this easily if I am using a value list that uses values from a related file, but this value list is a custom list.

I tried the using a pipe ex:

parts | P
Inventory | X

but this still returns the listed value in the SQL table. Is this possible?

Thanks for any insight.
Erich

2

I think you have to lose the spaces, like this:

text|id

Paul

3

thanks, these spaces are killing me, lol.

4

Nope, thats not it.

Thanks anyway

5

Are the value you’re passing into the dataprovider and the dataprovider of the same type?

Paul

6

yes, it is inserting the displayed text. The display text and the value I want inserted are the same data type : Text

7

Is the combobox field set to non editable? I would think that storing the ID would not work in the case of an editable field, since the system wouldn’t know what to put into the dataprovider in case of a user defined value.

Paul

8

JackPot.

Thank you kind sir!

9

:D