FiveTech Software tech support forums

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.

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

... Transform(year(fecha),"9999")+STRTRAN(Transform(etiqueta,"9999999999")," ","0") TAG "ETIQUETA" DESCENDING           regno:=recno()         (ccorte)->(DbSetOrder(5))         (ccorte)->(Dbgotop())  ...

... [lRecurse], [nCol] ) enhanced with three new parameters. Param.1 lAsc: .T. or "A" for ascending sort and .F. OR "D" for descending sort. Or, this parameter can be a codeblock also. Default: Ascending sort Param.2 lRecurse: Default .f. for backward compatibility If set ...

... using the value in oCol:cSortOrder. First click on the header sorts the data in ascending order. Second click on the header sorts the data in descending order. In case of DBF, it uses the RDD function OrdDescend() If oCol:cSortOrder is empty XBrowse does not attempt to sort. Note: FWH2304 ...

... using the value in oCol:cSortOrder. First click on the header sorts the data in ascending order. Second click on the header sorts the data in descending order. In case of DBF, it uses the RDD function OrdDescend() If oCol:cSortOrder is empty XBrowse does not attempt to sort. Note: FWH2304 ...

... this works just as normal ASort(), but if the fourth parameter is an array of column numbers, a nested sort is performed on multiple columns. For descending order, specify the column number as negative number. Eg: ASort( aArray,,{ 2, -4, 5 } ) Performs ascending sort of column 2 and where column ...

Set the sorted column's data cOrder := "A" or "D" depending on Ascending or Descending sort and then calll RefreshHeaders

Code: Select all  Expand view

oBrw:cOrders := ""
oCol:cOrder := "A"
oBrw:RefreshHeaders()

Yes, that's right. The problem is there when you want to combine dates and other data types. In this case you have to convert the dates to strings and here the codepage breaks the sort order of the descending string.

If user select a header to sort on or change ascending/descending order, how do I get xbrowse to always perform a oXbrw:goTop() afterwards?

No, as I want to sort for the second item descending and the first item ascending. Anyway, it doesn't work either.

EMG

https://vivaclipper.wordpress.com/2014/02/16/set-descending/

Saludos.

... ; [ALL] ; [NEXT <nNumber>] ; [RECORD <nRecNo>] ; [REST] ; [EVAL <bBlock>] ; [EVERY <nInterval>] ; [UNIQUE] ; [ASCENDING|DESCENDING] ; [USECURRENT] ; [ADDITIVE] ; [CUSTOM] ; [NOOPTIMIZE] ; [TEMPORARY] ; [USEFILTER] ; [EXCLUSIVE]

... ; [ALL] ; [NEXT <nNumber>] ; [RECORD <nRecNo>] ; [REST] ; [EVAL <bBlock>] ; [EVERY <nInterval>] ; [UNIQUE] ; [ASCENDING|DESCENDING] ; [USECURRENT] ; [ADDITIVE] ; [CUSTOM] ; [NOOPTIMIZE] ; [TEMPORARY] ; [USEFILTER] ; [EXCLUSIVE] como puede ver hay una clausula TEMPORARY ...