Re: [Gambas-user] How to sort a TableView?
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: > >> 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=/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=/4140 > ___ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > -- 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=/4140 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] [Gambas Bug Tracker] Bug #909: _TreeView_Item.Clear() throws Null object
http://gambaswiki.org/bugtracker/edit?object=BUG.909=L21haW4- Tobias BOEGE reported a new bug. Summary --- _TreeView_Item.Clear() throws Null object Type : Bug Priority : Medium Gambas version : 3.8.90 (TRUNK) Product : GUI components Description --- Code to trigger a "Null object" error from _TreeView_Item.Clear():325 basically looks like this: TreeView1["key"].Clear() Apparently the internal variable $aChildren is not initialised properly. Project attached. -- 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=/4140 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] [Gambas Bug Tracker] Bug #909: _TreeView_Item.Clear() throws Null object
http://gambaswiki.org/bugtracker/edit?object=BUG.909=L21haW4- Tobias BOEGE added an attachment: treeview-item-clear-0.0.1.tar.gz -- 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=/4140 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] How to sort a TableView?
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: > 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=/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=/4140 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Site Gambas-it.org comunication
The Gambas-it.org site is back online. Regards Gambas-it 2016-03-30 18:01 GMT+02:00 Gianluigi: > We inform that the Italian site Gambas (Gambas-it.org) is temporarily > unavailable because under crackers's attack. > We are arrange for. > > Regards > > Gambas-it > -- 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=/4140 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] How to sort a TableView?
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=/4140 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas on Windows™(c)(R) without doing anything?
If this were true, a Gambas's greater attention in favor of Ubuntu would be dutiful. :-D Regards Gianluigi 2016-03-30 19:24 GMT+02:00 Benoît Minisini: > Le 30/03/2016 19:21, Benoît Minisini a écrit : > > http://blog.dustinkirkland.com/2016/03/ubuntu-on-windows.html > > > > As we are not Friday yet, why not? > > -- > Benoît Minisini > > > -- > 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=/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=/4140 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas on Windows™©® without doing anything?
As I read this today I thought "does this mean I can run Gambas on Windows 10?" This means I can make programs for Windows users too :D Wohoo! -- 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=/4140 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
Re: [Gambas-user] Gambas on Windows™©® without doing anything?
Le 30/03/2016 19:21, Benoît Minisini a écrit : > http://blog.dustinkirkland.com/2016/03/ubuntu-on-windows.html > As we are not Friday yet, why not? -- Benoît Minisini -- 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=/4140 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Gambas on Windows™©® without doing anything?
http://blog.dustinkirkland.com/2016/03/ubuntu-on-windows.html -- Benoît Minisini -- 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=/4140 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
[Gambas-user] Site Gambas-it.org comunication
We inform that the Italian site Gambas (Gambas-it.org) is temporarily unavailable because under crackers's attack. We are arrange for. Regards Gambas-it -- 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=/4140 ___ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user