I've run into the problem of having default sorting done to list collections that I've applied an empty collections.sort to. It is very annoying if you've ordered the data on the server side and then the view shows it ordered using its default internal comparison.
You could try to read the data after you get it... but before you assign it to be a dataProvider/sorting/filtering. I have it on my todo list to take a look at having it restore the original order sometime. -Mark -----Original Message----- From: Deepak MS [mailto:megharajdee...@gmail.com] Sent: Tuesday, July 16, 2013 6:28 AM To: users@flex.apache.org Subject: Re: Flex AIR SQLite response Yeah, I did try mentioning the columns' order in query itself, but no luck. It still sorts alphabetically all the time(I tried out around 15 different queries with multiple columns). I'm not quite sure if its general database issue, since I tried to run those queries in ms sql and sqlite tools, I get the columns ordered as mentioned in my query. But in flex, no matter what order I mention or even when I give a *, it just sorts alphabetically. However, I am picking up the first row and looping to get the column names, sorting the columns and again rebuilding the data table to display. This whole process on device is taking time as I have around 200 columns(which are dynamic) that come from query. Had I got the query result without being sorted, I could have directly used it and could have avoided the above step. Kindly let me know if there is any other alternative for the step mentioned above. -Deepak
