FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour xbrowser, setorder DESC
Posts: 1956
Joined: Fri Oct 07, 2005 07:08 PM
xbrowser, setorder DESC
Posted: Sat Mar 09, 2024 04:14 PM

Hola.

Mi procedimiento almacenado en MARIADB devuelve la consulta ordenado por Fecha y Descendiente,

en el código luego hago un

acols[2]:setorder() (que es la columna fecha) y me lo ordena en forma ASCEndente.

como hago para que me lo ordene DESCENDENTE?

FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: xbrowser, setorder DESC
Posted: Mon Mar 11, 2024 06:59 AM

If we use AUTOSORT clause while defining XBrowse, when the user clicks on a header, it automatically toggles sort ascending and descending.

Regards



G. N. Rao.

Hyderabad, India
Posts: 1956
Joined: Fri Oct 07, 2005 07:08 PM
Re: xbrowser, setorder DESC
Posted: Tue Mar 12, 2024 04:43 PM

Ok.

Pero yo necesito que cuando muestre el xbrowser (al iniciar el programa) ya me muestre ordenado descendientemente por una columna.

FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/
Posts: 1710
Joined: Tue Oct 28, 2008 06:26 PM
Re: xbrowser, setorder DESC
Posted: Wed Mar 13, 2024 08:40 PM
Estimado goosfancito

Tenes que crear tu indice en DESCENDENTE
Code (fw): Select all Collapse
INDEX ON NOMBRE TAG NOM  DESCEND
.....

....
SET ORDER TO TAG NOM
Saludos,



Adhemar C.
Posts: 1344
Joined: Wed Nov 16, 2005 09:14 PM
Re: xbrowser, setorder DESC
Posted: Wed Mar 13, 2024 11:40 PM
goosfancito wrote: acols[2]:setorder() (que es la columna fecha) y me lo ordena en forma ASCEndente.
Code (fw): Select all Collapse
oBrw:aCols[2]:SetOrder()
oBrw:aCols[2]:cOrder := 'D'
De esta manenar te indica que el orden es descendente
Posts: 1956
Joined: Fri Oct 07, 2005 07:08 PM
Re: xbrowser, setorder DESC
Posted: Thu Mar 21, 2024 06:22 PM

gracias!

FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/
Posts: 1956
Joined: Fri Oct 07, 2005 07:08 PM
Re: xbrowser, setorder DESC
Posted: Mon Mar 25, 2024 04:29 AM
cmsoft wrote:
acols[2]:setorder() (que es la columna fecha) y me lo ordena en forma ASCEndente.
Code (fw): Select all Collapse
oBrw:aCols[2]:SetOrder()
oBrw:aCols[2]:cOrder := 'D'
De esta manenar te indica que el orden es descendente
Termino de probarlo pero no me lo hace che.
FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: xbrowser, setorder DESC
Posted: Mon Mar 25, 2024 04:49 AM

If the column is already ordered oCol:SetOrder() toggles ASC and DESC.

You need not have set aCols[ 2 ]:SetOrder() because it was already in the descending order.

Regards



G. N. Rao.

Hyderabad, India
Posts: 1956
Joined: Fri Oct 07, 2005 07:08 PM
Re: xbrowser, setorder DESC
Posted: Mon Mar 25, 2024 08:48 PM

ok.

And so that the column that is ordered by "SELECT" appears the TRIANGULITE as it is done?

FWH 21.02
Harbour 3.2.0dev (r2104281802)
Copyright (c) 1999-2021, https://harbour.github.io/

Continue the discussion