FiveTech Software tech support forums

We are aware that the user can change the sort order of columns by clicking on the header in autosort mode. There are many programmers who like to provide a combobox to change the sort order additionally. In this case, programmers are often facing difficulty in perfectly ...

... Now, we want to browse fields FIRST,CITY,STATE,AGE,SALARY. Out of the 5 columns we have index on FIRST and CITY only. But we like the browse to autosort on STATE and AGE also. Then we can do: USE CUSTOMER NEW SHARED VIA "DBFCDX"FW_CdxCreate( "STATE,AGE", .t. )SET ...

... "Tema", "" ; COLSIZES -10, -10, -10, -10 OF oDlg ; SIZE 400,285 PIXEL ; JUSTIFY .T., .f., .f.,.f. ; ALIAS cAlias AUTOSORT FOOTERS LINES CELL NOBORDER ; BACKGROUND aGrad VERTICAL oBrw:nStretchCol := 2 Por que puede dar el mismo error en los 2 casos? agradecere su ...

... .F.,.F.,.F.,.F.; FIELDSIZES 590, 70, 70, 80 ; PICTURES "@!",'99,999.99','999,999,999','999,999,999' ; DATASOURCE aData[I] FOOTERS AUTOSORT; LINES CELL cols{ 1,2,3,4 } OF oFld:aDialogs[ I ] oBrw[I]:nColDividerStyle := LINESTYLE_BLACK oBrw[I]:nRowDividerStyle := LINESTYLE_BLACK oBrw[I]:nMarqueeStyle ...

xbrowser(aGroepen) FASTEDIT AUTOSORT SHOW RECID Title "Downloadlijst voor de groepen" Xbrowse WITH OBJECT oBrw :lEditMode := .T. :lFooter := .t. :bRecSelHeader := { || "" } :bRecSelData := { |o| o:KeyNo } :bRecSelFooter ...

... the same text on xbrowse as the fields @ 30,10 XBROWSE oBrw SIZE -10,-10 PIXEL OF oDlg ; COLUMNS aFlds HEADERS aFlds ; DATASOURCE uDataSource AUTOSORT CELL LINES NOBORDER but the search take the name of the Items of combobox https://i.postimg.cc/sgQXK08t/hj.jpg

... PICTURES "@Z 9999999","@Z 9999","@Z 99",NIL,"@Z 999,999.99"; JUSTIFY {AL_RIGHT,AL_RIGHT,AL_RIGHT}; FOOTERS AUTOSORT BACKGROUND oApp:cBrush WITH OBJECT oBry :l2007 := (.F.) :lHScroll := (.F.) :lVScroll := (.F.) :lFooter := (.T.) :nMarqueeStyle := MARQSTYLE_HIGHLROWMS ...

... 5 2 LASTCHANGE Date 8 0 */ DEFINE DIALOG oDlg SIZE 1100,600 PIXEL @ 40, 20 XBROWSE oBrw SIZE -20,-20 PIXEL OF odlg; DATASOURCE "ITEMS" AUTOSORT; COLUMNS "CCODE", "DETAIL", "PVP1", "PVP2", "PVP3", ARTIVA,"LASTCHANGE"; CELL LINES ...

... }}    local oDlg, oBrw    DEFINE DIALOG oDlg RESOURCE "TEST"    REDEFINE XBROWSE oBrw ID 101 DATASOURCE aData ;       COLUMNS 1, 2, 3 AUTOSORT    ACTIVATE DIALOG oDlg CENTERED ON INIT ( oBrw:aCols[ 1 ]:SetOrder(), oBrw:GoTop() ) return nil Mr. Rao Con array si funciona el orden descendente ...

... "Del.", "Date", "Author or file", "Like", "Keyword or Info1", "Keyword or Info2" ; AUTOSORT LINES NOBORDER FONT oMono ; ALIAS cFileName UPDATE XbrSetupBar( oBrw ) ... ... //----------- only some buttons !!! ------------------------- ...

... ; FIELDSIZES aFSize[1] ; PICTURE aPict[1] ; JUSTIFY aJust[1] ; FONT oFntX7A ; ALIAS cAlias ; FASTEDIT ; LINES ; CELL ; FOOTERS ; AUTOCOLS ; AUTOSORT oBrw:l2007 := .T. oBrw:nRowHeight := 20 oBrw:nColDividerStyle := 3 //LINESTYLE_BLACK oBrw:nRowDividerStyle := 3 //LINESTYLE_BLACK oBrw:lColDividerComplete ...

Hi,
My xbrowse has autosort. How can I automatically change :cFilterFld based on which col header user clicks?

TIA

... 5 2 LASTCHANGE Date 8 0 */ DEFINE DIALOG oDlg SIZE 1100,600 PIXEL @ 40, 20 XBROWSE oBrw SIZE -20,-20 PIXEL OF odlg; DATASOURCE "ITEMS" AUTOSORT; COLUMNS "CCODE", "DETAIL", "PVP1", "PVP2", "PVP3", ARTIVA,"LASTCHANGE"; CELL LINES ...

In the COLUMNS clause, we can include expressions also, as long as the expression can be evaluated in another module, i.e., expressions not containing local variables or static functions. The above can be written as COLUMNS "IMPORTE+(IMPORTE*IVA/100)-(IMPORTE*IRPF/100)", "NEXTCOL"...

Thank you.

But in some xbrowse cols, I have defined the field like this:

( CONCEPTO->IMPORTE + (CONCEPTO->IMPORTE*CONCEPTO->IVA/100) - (CONCEPTO->IMPORTE*CONCEPTO->IRPF/100) )

But in COLUMNS clause does not work. How should I proceed please?