Ordenar un GRID

HMG en Español

Moderator: Rathinagiri

Post Reply
jorge.posadas
Posts: 192
Joined: Mon May 19, 2014 7:43 pm
DBs Used: DBF, SQLite, MS-SQL, ACCESS, MariaDB (en proceso)
Location: Morelia, Mich. México
Contact:

Ordenar un GRID

Post by jorge.posadas »

Grupo

¿Cómo puedo hacer para ordenar un grid con una columna que yo desee?

De antemano agradezco la ayuda
Cordialmente

POSADAS SOFTWARE
Jorge Posadas Ch.
Programador independiente
Morelia, Mich.
M é x i c o .
Movil +52 44 3734 1858
SKYPE: jorge.posadasch
Email: jorge.posadas@posoft.mx
User avatar
serge_girard
Posts: 3342
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: Ordenar un GRID

Post by serge_girard »

Hi,

you can use something like this:

Code: Select all

ON HEADCLICK { {|| Sort_Grid_XFER(1)}  , { || Sort_Grid_XFER(2)} , { || Sort_Grid_XFER(3) } , { || Sort_Grid_XFER(4) }  } ;



FUNCTION Sort_Grid_XFER(t)
/************************/
LOCAL nATL := Form_SL_XFER1.Grid_XFER.ItemCount
DECLARE nF [ nATL, 4 ]
 
FOR I := 1 To nATL
	aItem		:= Form_SL_XFER1.Grid_XFER.Item ( i )  
	nF [i,1]	:= aItem [1]   // use val or ctod if necessary !!!
	nF [i,2]	:= aItem [2] 
	nF [i,3]	:= aItem [3] 
	nF [i,4]	:= aItem [4] 
NEXT A

aSortnF := ASORT(nF,,, { |x, y | x[t] < y[t] } )

DELETE ITEM ALL FROM Grid_XFER OF Form_SL_XFER1
AEVAL( nF, {| elem | add_item(elem, 'Form_SL_XFER1' , 'Grid_XFER' ) } )
RETURN


FUNCTION add_item(elem, form, gridz )
ADD ITEM {elem[1] , elem[2], elem[3], elem[4] } TO &gridz OF &form
RETURN

S
There's nothing you can do that can't be done...
User avatar
nekbmm
Posts: 126
Joined: Sat Jul 16, 2016 3:16 am
DBs Used: DBF,SQLite
Location: Ivanjica, Serbia

Re: Ordenar un GRID

Post by nekbmm »

Thanks for sharing.

NEX.
jorge.posadas
Posts: 192
Joined: Mon May 19, 2014 7:43 pm
DBs Used: DBF, SQLite, MS-SQL, ACCESS, MariaDB (en proceso)
Location: Morelia, Mich. México
Contact:

Re: Ordenar un GRID

Post by jorge.posadas »

Gracias Serge_Girad

Lo voy a probar en mi programa
Cordialmente

POSADAS SOFTWARE
Jorge Posadas Ch.
Programador independiente
Morelia, Mich.
M é x i c o .
Movil +52 44 3734 1858
SKYPE: jorge.posadasch
Email: jorge.posadas@posoft.mx
Post Reply