Re: Populate with SQL [XPA 2.5]


Florian Groothuis
 

If you use an “order by” on converted numerics you get this 14,40,7,9. Should be 7,9,14,40 as numeric.

 

I solved this issue by making 2 subtasks, numeric and alphanumeric, and sending an additional parameter. Works now.

 

Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens harry@...
Verzonden: dinsdag 13 juni 2017 20:06
Aan: main@magicu-l.groups.io
Onderwerp: Re: [magicu-l] Populate with SQL [XPA 2.5]

 

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.