AnsweredAssumed Answered

Magic List value concatenation when using second column

Question asked by philparton on Dec 8, 2016
Latest reply on Dec 9, 2016 by okramis

Hi,

 

As an FM newbie I have just worked my way through magic lists. The single column list is working fine but when doing a one using a second column I the list values are concatenating and its seems to be affected by the sort setting.

 

I have a table Code with fields ID (numeric) and Name (text) with 4 records

1, code 1

2, code 2

3, code 3

4, code 4

 

I created a two column magic value list using the following sql in the field OnObjectEnter trigger

$$keys = select id from code

$$names = select name from code

 

If I select to see both fields and sort on the first field my popup menu displays:

 

1 Code1Code2Code3Code4

2 Code1Code2Code3Code4

3 Code1Code2Code3Code4

4 Code1Code2Code3Code4

 

But it can store the selected ID correctly.

 

If I select to see both fields and sort on the second field my popup menu displays:

 

1234 Code1

1234 Code2

1234 Code3

1234 Code4

 

and when an option is selected I get the non-numeric value / revert field dialog.

 

I am using the default delimiters in the ExecuteSQL call.

 

Any ideas?

 

Thanks

Phil

Outcomes