Re: Populate with SQL [XPA 2.5]


Harry Kleinsmit
 

Use an 'ORDER BY' in your SQL select ?


On Tue, Jun 13, 2017 at 06:30 am, Florian Groothuis wrote:

 

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.