Hi,
I cannot manage to obtain my Sql list in the right order. I have even tried to create an "_ORDER" field with integers without success with the "order by" clause in my Sql...
I believe it is related to the fact that my Itemkeys are strings, so that I obtain:
1
10
11
12...
2
20...
Any ideas???
Thank you
Jerome
Number them like this:
01
02
03
...
12
20
21
22
The _Order field is text? make it integer.
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
Thank you Paul, I'll try something on those lines. It would be interesting only if it works without changing the data values themselves though...
Thanks Phil, but it's already integers I'm afraid. It looks like the Sql statement treats everything as text.
if you are running this sql on a report, your field data type must be text, change it to integer.
If you're running this in a gci, then yes gint puts everything in a temp database and all fields are text, so use cdbl(fieldname) in order by