> Hi my friends.
> In a recent thread about sorting a grid by header clicks, I posted a way I used to do that.
> I improved it a little bit and posted a sample form in my blog with some explanation of the procedure.
>
> It may be useful to some of you.
>
> My Foxite Weblog
>
> sample form to download:
> http://www.foxite.com/uploads/5c545b64-b731-4c6f-bae4-4e20ed0c6c5b.rar
>
> sample form picutre:
>
>
>
> Best regards.
>
> Ammar Hadi ................IRAQ
>
> ---------------
> I I I really love foxite
> ___________________________

Hi Ammar and thanks for sharing your code.
i just have one remark: you repeat pratically the same code in all click event of the headers (safe the numero of index).I recommend you to work with bindevent in any click on any header,if concerned by the sorting.try this code:

in form.init add

		for i=1 to this.grdsort.columncount
		if inlist(i,1,2,3)  &&choice only the column to sort asc/descending-grid can have any columnCount
		aa="this.grdsort.column"+trans(i)+".header1"
		bindevent(&aa,"click",thisform,'ybind')
		endi
		endfor

and create a method "ybind" with this code

		x=sys(1270)
		n=val(right(allt(x.name),1))

		SELECT tempStudents
		IF VAL(SYS(21))<>n  && current index number
		  SET ORDER TO n IN tempStudents
		ELSE
		  IF DESCENDING(n,"tempStudents")
		    SET ORDER TO n IN tempStudents ASCENDING

		  ELSE
		    SET ORDER TO n IN tempStudents DESCENDING

		  ENDIF
		ENDIF
		THIS.grdsort.SETALL("picture","","HEADER")

		y="this.grdsort."+allt(x.name)+".header1.picture"
		&y=IIF(DESCENDING(n,"tempStudents"), THISFORM.picdesc, THISFORM.picace) && the sorting icon

		GO TOP IN tempStudents
		THIS.grdsort.REFRESH
		THIS.grdsort.SETFOCUS

with this you can generalize to any grid with any columncount.
I see this remarkable opportunity in Listview controls and even in subclass of grids.


Dont rate please.its only for the pleasure to help.Give me only a feed back.
Yousfi Benameur