[Gambas-user] How to sort a TableView?

[T Lee Davidson]

Thank you for your effort, Gianluigi. But, I am not using a database; just a TableView of data.

When a TableView's Sorted property is set to True, clicking on a column header toggles the sort indicator and raises the 
TableView's Sort event.

I need to sort the TableView rows based on the values in whichever column the header was clicked.


On 03/30/2016 06:06 PM, Gianluigi wrote:
> Not sure if I understand the question, but something like that, could help?
>
> If TableView1.Columns.Ascending Then
>    sMySql = "SELECT *"
>    sMySql &= " FROM customers"
>    sMySql &= " ORDER BY surname ASC,"
>    sMySql &= " name ASC"
>    sMySql &= ";"
> Else
>    sMySql = "SELECT *"
>    sMySql &= " FROM customers"
>    sMySql &= " ORDER BY surname DESC,"
>    sMySql &= " name DESC"
>    sMySql &= ";"
> Endif
>
> Regards
> Gianluigi
>
> 2016-03-30 22:18 GMT+02:00 T Lee Davidson <t.lee.davidson at ...626...>:
>
>> The documentation for TableView shows a Sorted property which says,
>> "Sorting the data is not done automatically. It must be done
>> by user code." But, the page does not give any clues regarding how to
>> accomplish that. Though, obviously, sorting should be done
>> in the Sort event handler.
>>
>> In the past, I have used an array of objects to store the data represented
>> in the TableView. This provided use of Object[].Sort
>> with the _compare function.
>>
>> This time around, I am attempting to eliminate the redundancy of duplicate
>> data containers (store and view) and the cumbersome
>> syncing of the data and the view. (Perhaps I should just simply use a
>> SQLite DB and a DataView?)
>>
>> There appears to be no TableView/GridView or GridView.Columns Sort method.
>>
>> Does anyone have any hints as to how to sort a TableView?
>>
>>
>> --
>> Lee
>> __________
>>
>> "Artificial Intelligence is no match for natural stupidity."
>>
>>
>> ------------------------------------------------------------------------------
>> Transform Data into Opportunity.
>> Accelerate data analysis in your applications with
>> Intel Data Analytics Acceleration Library.
>> Click to learn more.
>> http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140
>> _______________________________________________
>> Gambas-user mailing list
>> Gambas-user at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/gambas-user
>>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>

-- 
Lee
__________

"Artificial Intelligence is no match for natural stupidity."