Andre.Bisseret at inria.fr
Thu Apr 22 14:35:54 EDT 2010
Seems this one might be working as you expected (?)
-- in the script of the dataGrid: -------
put the dgHeaderControl of the mouseControl into hcColumn
if hcColumn is not empty then
put the dgColumn of the target into theColumn
if theColumn is "date" then
dispatch "sortByColumn" to the target with "date"
wait 1 sec
set the dgColumnSortDirection["number"] of the target to
"ascending" -- may be not necessary
dispatch "sortByColumn" to the target with "number"
Le 22 avr. 10 à 11:38, Marcello Bertoli a écrit :
> Hi Andre,
> thank you very much for your answer. I tried your code but it
> doesn't do the job. It is like pushing the column header of the
> datagrid two times (first the number one and the the date one).
> My data come from a sql base so I can (as Steven said) make the
> query do the work of the multiple sorting before loading into the
> datagrid but I'm scared about performances when it comes to manage
> hundreds of thousands of data. In this scenario I need to retrieve
> data from the sql base and then populate the datagrid every time I
> need to sort the rows without the data I already have in the
> datagrid. This means more traffic over the network and multiple
> populations of the datagrid...
> Best regards
> On 21/apr/2010, at 19.33, Andre.Bisseret wrote:
>> I think yes! Assuming for instance you want the dates sorted from
>> the oldest down to the more recent
>> and then, for each date, the numbers should be sorted from the
>> smaller down to the greater
>> you should sort the numbers column first then the dates' column.
>> Something like that:
>> on mouseUp
>> ##setting the sort type value for each column
>> set the dgColumnSortType["date"] of grp "datagrid 1" to "system
>> set the dgColumnSortType["number"] of grp "datagrid 1" to "numeric"
>> set the dgColumnSortType["title"] of grp "datagrid 1" to text
>> ## making sure the two columns will have the same sortDirection if
>> set the dgColumnSortDirection["date"] of grp "datagrid 1" to
>> set the dgColumnSortDirection["number"] of grp "datagrid 1" to
>> ## sort "number" first then "date"
>> dispatch "sortByColumn" to grp "datagrid 1" with "number"
>> dispatch "sortByColumn" to grp "datagrid 1" with "date"
>> end mouseUp
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the Use-livecode