Valuelists in 3.5.7

Classic Servoy
1

Hi,
I get an error of invalid input (the dataprovider is integer and the value is text) when changing values in table view.
I’m not sure if it is a bug or wrong usage, but for sure the behavior in 3.5.6, where I have a different problem, is different.

When it occur:
I display an Entry table in a table view for data editing.
There is a combobox for the field “Category” (all values of the Category table)
and a combobox “Value” the shows all available Values of the selected Category. There is a relation between table Entry and table Values, based on common field “Category”.

If I select the “Value” combo of record where is assign i.e. the category A and after a record with a different category, appears the error.
Actually, each time that the valuelist have to change.

The same solution , in 3.5.6 gives no error, but changes the “value” according to last selected value.
If for example I select the 10th value of category A and after press the combo of a record where is assigned the category B, it is assigned the 10th value of category B.

Do I have to set differently the relations of the valuelist ?

2

There was a similar problem with list view and combos. That one was fixed - not sure it is the same one here though.
Please create a case in our support system and attach a small sample solution we can use to reproduce the problem.
http://crm.servoy.com/servoy-webclient/ … oy_support

Thanks.

3

I think I see the same problem. It seems to be table view only and the value list uses display/return values.

4

Case created, with attached sample solution.

I switched to list view and it works properly.

5

Hi to all,
While waiting for the fix I have used a list view, that has a different problem.

In my Entry table I have two combos. One for the “category” selection (from the categories table) and one for the “value” selection (from the values table).
The Value" table has a composite key (category_id and value_id).
So, there is a relation between the Entry table and Value table, based on the category id.

While selecting a row, the lookup description of the various “values” changes by taking the description of values with same id, but different category.

Is it a bug ?

6

By using the type ahead control instead of the combo, it works correctly.

Ric

7

nric wrote:
While selecting a row, the lookup description of the various “values” changes by taking the description of values with same id, but different category.
Is it a bug ?
Yes. I think it is a bug Servoy. We have lost a lot of time.

nric wrote:
By using the type ahead control instead of the combo, it works correctly.
Yes, I too have noticed that most(three) valuelist on the same line in tableview do not work in combobox (only the first!), But putting the second and a third type ahead, then work (it seems).
Three combobox in tableview in Servoy 4.x work (it seems).

I hope this is at least comforting to Nric.
I have the same problems outlined by nric, and explained in the post of 5-12-2008 to:
http://forum.servoy.com/viewtopic.php?f=22&t=11204
Windows XP
Java 11.0
Servoy 3.5.7