Re: Populate with SQL [XPA 2.5]

Tim Downie

It will work if you get your sql task right - would be nice if you could just populate combo direct from sql statement.

In sql task type in the sql and press apg ull get the correct virtuals then go in and add link create/write
From: <> on behalf of Florian Groothuis <f.groothuis@...>
Sent: Tuesday, 13 June 2017 1:30:28 PM
Subject: Re: [magicu-l] Populate with SQL [XPA 2.5]

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.