List View Refresh

[boogieoompa]

I have a program that creates a listview box (using the _GUICtrlListView_* UDFs) and queries an access database. Everytime the database is queried I use _GUICtrlListView_DeleteAllItems and than I add the new query. I have added _GUICtrlListView_SortItems($mainlist, GuiCtrlGetState($mainlist) to the end of each population function however it is sorting everything in reverse (ie if the user had the ListView sorted by last name A-Z the list will repopulate after refresh being sorted by last name Z-A).

Am I using this function right?

Thanks

[boogieoompa]

I just thought of a very ghetto fix... I included the function twice. Hacky and ugly but at least it works. I would still love to hear if there is a better way. I'm pretty sure I know what the problem is, when I populate the listview with my SQL querey it populates in the order that I add items even though the little triangle marker shows that the list SHOULD be sorted by a specific column. When I call the sort command it just simply flips the arrow.

I gather that the sort command doesnt realize that the data wasn't really sorted before I call the sort command.

Thanks

[FireFox]

Hi,

You can save the current column sorted and if it's not already sorted then sort it.

Br, FireFox.

[kylomas]

boogieoompa,

Why not use the SQL stmt to return data in the order that you want?

kylomas

[BrewManNH]

Add one of these Listview styles to the Styles parameter setting when you create the listview and it will sort the items as you add them automatically.

$LVS_SORTASCENDING ; Item indexes are sorted based on item text in ascending order
 $LVS_SORTDESCENDING ; Item indexes are sorted based on item text in descending order

Edited April 12, 2013 by BrewManNH

[boogieoompa]

Thanks for the replies! Solution implemented :-).