Strange related value list problem

Classic Servoy
1

Hello,

I have a strange problem. I have a value list that uses a N:M relation to get the values. The setup looks like this

table A → A:B → table B

I use this kind of setup on different occasions without problems. Only in one form I get lots of errors only sometimes in the console. At the end, the value list works as expected. The query that is generated by Servoy is this:

16:26:34 ERROR: select distinct v_k_klassifikation_3.uid_v_k_klassifikation_3,v_k_klassifikation_3.kontaktklassifikation_3 from v_k_klassifikation_3_to_2 where v_k_klassifika
tion_3_to_2.uid_v_k_klassifikation_2 = ? and v_k_klassifikation_3.uid_v_k_klassifikation_3 = ?

As one can easily see, the table v_k_klassifikation_3 that is used to get the actual values, is not in the from clause what causes the error.

Servoy 3.1.6

Thanks
Patrick

2

Patrick,

Where are you using this value list?
In a combo box or a type ahead or something else?

Rob

3

Combobox. Not editable.

4

Hi Patrick,

Please create a small sample solution for this problem and file a case in our support system.
See http://forum.servoy.com/viewtopic.php?t=6789
Rob

5

I don’t think that’s possible. I am using this setup on different tables without problems. Only this one gives me trouble. So I don’t think I can recreate it.