selection list from string

Thu, 13 Sep 2012 08:30:59 GMT

hello

I would like to know if it's possible to load a selection list with values that I have in a string. for example we have

SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

and I would like to have in my selection list box values :lun. ,mar.,....

2. how can i link this day with a field that I have in a table? via a join? so absolutely need to create an INLINE object with those daynames first?

thks

Valery

Re: selection list from string

swuehl — Thu, 13 Sep 2012 08:54:53 GMT

Your DayNames is just a string variable, so you can't select values from that.

But you can create a field from your variable like:

SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

DayName:

LOAD subfield('$(DayNames)',';') as Dayname

AutoGenerate 1;