How do I change the direction of the sort using a script?

Is there any way to make collum sort permanent? it mean, we update dataGrid by script (not user click), sort still work automatically. Yes it is there is sort by script above, but after update we have to run that script again and again and it make the speed slower. Thanks

Adding the following empty handler


on SortDataGridColumn pColumn
 end SortDataGridColumn



to the Datagrid script should do what you want.

@Ben.Brannen
There are several ways to do it.

You can use the property dgColumnSortDirection

set the dgColumnSortDirection["col1"] of group "Data Grid" to "ascending"

possible values are ascending or descending

or you could use the command SortDataByKey

dispatch "SortDataByKey" to group "DataGrid 1" with pArrayKey, pSortType, pDirection, pCaseSensitive

where

pArrayKey is the columname
pSortType can be numeric,text,international, datetime

pDirection can be ascending, descending

pCaseSensitive can be TRUE, FALSE

@Matthias Rebbe
I put this on dataGrid Script did not works for me
on SortDataGridColumn pColumn
end SortDataGridColumn

Hm,
i just tried it here again. Without that handler i can click on the columns header to sort and sorting works. If i add the two lines to my Datagrid script , then clicking on the columns headers to sort does not work.

@Matthias Rebbe
Yes it mean disable Sort.
What I want to do is Sort Permanent. event data grid updated with this script
http://lessons.livecode.com/m/datagrid/l/7315-how-do-i-update-data-in-a-row

It seems i´ve misunderstood your origin question, please excuse. I am sorry, but i have no answer then for you, but i am sure someone of the Livecode stuff will answer.

Hi @Matthias Rebbe ...
i appreaciate your comment

Hi Gilar

You should be able to resort after adding update the content by using the SoryByColumn command e.g.

dispatch "SortByColumn" to group "DataGrid" with "name"

I hope that helps.

Kind regards

Elanor

Hi @Elanor Buchanan
I have tried this
dispatch "SortByColumn" to group "DataGrid" with "name"
but it make data grid slow,
FYI: my apps get data feed and update about 80 line/second.
so i update about 80 times / second
it feel slow when i have to run sort script every time update