Re: Populate with SQL [XPA 2.5]


Florian Groothuis
 

I got it right, see my previous message. And yes, indeed, it would be nice if we could do so.

 

Gr

Florian

 

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


Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Tim Downie
Verzonden: dinsdag 13 juni 2017 15:44
Aan: main@magicu-l.groups.io
Onderwerp: Re: [magicu-l] Populate with SQL [XPA 2.5]

 

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: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Florian Groothuis <f.groothuis@...>
Sent: Tuesday, 13 June 2017 1:30:28 PM
To: main@magicu-l.groups.io
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: 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.