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.david...@gmail.com>: > 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@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user