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 On Mon, Jul 15, 2013 at 7:17 PM, Justin Mclean <jus...@classsoftware.com>wrote: > Hi, > > SQL column order should never be assumed, there is no way to order columns > and it could even possibly vary query by query (in practice it doesn't). > This isn't a Flex issue but a general database issue. > > You might be able to select the columns in order by specifying them in the > select statement in the order you want rather that a select * but it would > be best to change to code to not rely on the order of the columns. > > Justin
