Re: [Gambas-user] How to sort a TableView?

2016-03-30 Thread 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 :
>
>> 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

2016-03-30 Thread bugtracker
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

2016-03-30 Thread bugtracker
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?

2016-03-30 Thread Gianluigi
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

2016-03-30 Thread Gianluigi
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?

2016-03-30 Thread 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


Re: [Gambas-user] Gambas on Windows™(c)(R) without doing anything?

2016-03-30 Thread Gianluigi
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?

2016-03-30 Thread Moviga Technologies
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?

2016-03-30 Thread 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


[Gambas-user] Gambas on Windows™©® without doing anything?

2016-03-30 Thread Benoît Minisini
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

2016-03-30 Thread 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