Re: Populate with SQL [XPA 2.5]

Florian Groothuis

This could work except when the results are numeric values. Casting them as alpha-numeric values messes up the ordering, when I use a numeric virtual as output variable I get this:



Van: [] Namens harry@...
Verzonden: dinsdag 13 juni 2017 14:48
Onderwerp: Re: [magicu-l] Populate with SQL [XPA 2.5]


Hi Florian,

You could use a direct sql task with the whole sql select as a parameter and build your combobox string from that. You could send this back as the return parameter.

Best regards,
Harry Kleinsmit.

Met vriendelijke groet - With kind regards,

Florian Groothuis
+31 (0)6 21927914

Meilink Beheer Borculo B.V. • Kamerlingh Onnesstraat 1
7271 AZ  Borculo • Nederland • +31 (0)545 253525
KvK 08009803 • Our general terms and conditions apply • Disclaimer

Join to automatically receive all group messages.