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: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens harry@...
Verzonden: dinsdag 13 juni 2017 14:48
Aan: main@magicu-l.groups.io
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
Analist/programmeur
+31 (0)6 21927914


meilink.eu

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 main@magicu-l.groups.io to automatically receive all group messages.