FiveTech Software tech support forums

... in the statement #xcommand: #xcommand @ <nRow>, <nCol> [ COLUMN ] XBROWSE <oBrw> ; ... the line: [ SELECT <cField> FOR <uValue1> [ TO <uValue2> ] ] ; should be deleted Your thougths please... Regards, Euclides

... ] ; [ SIZE <nWidth>, <nHeigth> ] ; [ ID <nID> ] ; [ <dlg:OF,DIALOG> <oWnd> ] ; [ SELECT <cField> FOR <uValue1> [ TO <uValue2> ] ] ; [ <change: ON CHANGE, ON CLICK> <uChange> ] ; ... Vos deberías usar oBrw:bChange:= {|| ... } (porque ...

... the select clausule in xbrowse.ch #xcommand @ <nRow>, <nCol> [ COLUMN ] XBROWSE <oBrw> .... ; [ SELECT <cField> FOR <uValue1> [ TO <uValue2> ] ] ; Taking Testxbr3.prg as sample , i changed in RddBrwAllColsWin : @ 0,0 XBROWSE oBrw OF ownd ALIAS cAlias ; AUTOSORT ...

Antonio,

Thanks.

I'll try it.

in: SELECT <cField> FOR <uValue1> [ TO <uValue2>]

How do I write cField? is it the name of the field or in " "
and, the uValue1 - is it an expression the returns true / false?


Moshe Yarden

Moshe, > I was trying: SELECT <cField> FOR <uValue1> [ TO <uValue2>] In order to use that clause, you need to have an index built with the expression to be searched. Alternatively you can use OrdScope() to set a top and bottom range ...

... "MasLoad->Manifest == cManifest .and. MasLoad->TalyFlag" where Manifest is C and TalyFlag is L I was trying: SELECT <cField> FOR <uValue1> [ TO <uValue2>] But I'm doing something wrong. *. Is there a way to use something like AChoice()? *. Is there a picklist that does ...

... code block to change the // behavior of pressed keys DATA cAlias // data base alias or "ARRAY" or "TEXT_" DATA cDriver // RDD in use DATA cField, uValue1, uValue2 // SetFilter Params DATA cOrderType // index key type for seeking DATA cPrefix // used by TSBrowse search feature DATA cSeek // used ...

Puedes usar la claúsula [ SELECT <cField> FOR <uValue1> [ TO <uValue2> ] ] que es mucho más rápida que un filtro pues se basa en un índice. Ejemplo: INDEX ON Clientes->Nombre TO CliName SET INDEX TO CliName GO TOP REDEFINE LISTBOX ...

... <aHeaders,...> ] ; [ SIZE <nWidth>, <nHeigth> ] ; [ <dlg:OF,DIALOG> <oWnd> ] ; [ SELECT <cField> FOR <uValue1> [ TO <uValue2> ] ] ; [ <change: ON CHANGE, ON CLICK> <uChange> ] ; [ ON [ LEFT ] DBLCLICK <uLDblClick> ] ; [ ON ...

... extern DBSKIP //----------------------------------------------------------------------------// CLASS TWBrowse FROM TControl DATA cAlias, cField, uValue1, uValue2 DATA bLine, bSkip, bGoTop, bGoBottom, bLogicLen, bChange, bAdd DATA nRowPos, nColPos, nLen, nAt, nColAct // nColPos -> 1ra. Columna ...

... <aHeaders,...> ] ; [ SIZE <nWidth>, <nHeigth> ] ; [ <dlg:OF,DIALOG> <oDlg> ] ; [ SELECT <cField> FOR <uValue1> [ TO <uValue2> ] ] ; [ ON CHANGE <uChange> ] ; [ ON [ LEFT ] CLICK <uLClick> ] ; [ ON [ LEFT ] DBLCLICK <uLDblClick> ...

... etc... Yo no utilizo el Browse de FiveWin, pero en el manual, se puede leer en la definición LISTBOX la línea: [ SELECT <cField> FOR <uValue1> [ TO <uValue2>] ] <uValue1> y <uValue2> representan los límites del SCOPE Algunos programadores prefieren utilisar un ...

... current Index Key type!" ) I think that buildskip is worg too when using the above example at line : static function BuildSkip( cAlias, cField, uValue1, uValue2 ) local bSkipBlock local cType := ValType( uVal1 ) regards, A.S.K