I need to implement a sorting capability on a partial area of a listbox. There are 5 columns per row of information that when sorted need to stay together.
There are two specific types that are always defined in column-1. In each row columns 0-5 need to be copied. There are more columns that 5 but only need to deal with these columns in each row. I have implemented a way to identify each sets beginning row and have this method able to address variable listbox rows.
The thought is to copy the rows of a specific type into an array or dictionary. I have used multidimensional arrays before but from what I have read a dictionary may be the better direction. If so how to use a dictionary with multiple (columns?) alludes me and then how to sort and maintain data integrity. Or is this not a way to use a dictionary and if not what would be a good way to accomplish.
I see how to do this with a db as well but perhaps this is time to learn dictionaries beyond the simple example XOJO provides.
FYI: After doing the sorting I would use the Dictionary info to write back to the listbox then perform a db update of that newly sorted data in that Listbox.
Any thoughts on which direction and how to begin?