FiveTech Software tech support forums

... can be cases where when user modifies the value of a column, some other column's value may need to be changed based on some calculation. oCol:bOnChange codeblock is intended for this purpose. Example usage: oBrw:Quantity:bOnChange := { |oCol, uOldVal| oBrw:Sales:VarPut( oCol:Value * oBrw:Price:Value ...

... .... oGet:cText := <replace> endif return .t. If we want to modify another field consequent on a user input in a column we may use oCol:bOnChange oCol:bOnChange := { |oCol,uOldValue| OnColChange( oCol, uOldValue ) } func OnColChange( oCol, uOldValue ) FIELD->PASSED := oCol:Value > ...

I tried with bOnChange method but it not run ok or I not Know how set the right variable

sample
:bOnChange := { |oCol, uOldVal| MyFuncOnChange( oCol, uOldVal ) }

... codeblock was necessary). You wanted that once a column is edited, another field is to be changed automatically. This is to be achieved by oCol:bOnChange := { || oOtherCol:VarPut( <dependantvalue> ) } Now let me post a revised sample of your code: @ 0,0 XBROWSE oBrw OF oDlg RECORDSET oRs ...

Thanks Rao!

When user checked a row, I want to display a message at the top using a say control. That can now be accomplished using bOnChange.

However once user click somewhere else, in other words the col lost focus, I want to erase that message. Is there such a bLostFocus data?

TIA

oCol:bOnChange := { |oCol, uOldVal| MyFuncOnChange( oCol, uOldVal ) }

... 2010 style xbrowse column menus are also shown with 2010 style. * Enhancement: Method Report() prints page numbers at bottom center. * Fix: oCol:bOnChange was not getting triggered when the change is only in the case. Now fixed. * New: DATA bEdit. { |oRec| MyEdit( oRec )}. This data is used by ...

Holas,

he solucionado este problema definiendo oCols:lAutoSave := .F. en la columna correspondiente, este comportamiento se da en los metodos, bOnPostEdit, bEditValid, bOnChange, por lo que creo que es un bug de xBrowse

saludos

Marcelo

Hello Mr. Rao,

thanks for response, finally I found the problem, the strange behavior is when set oCol:lAutoSave := .T. , this behavior is in all the the method bEditValid, bOnPostEdit, bOnChange, then I think this is a bug in xBrowse

Muchas gracias

saludos

Marcelo

... is limited only to validate the input and return valid or not. If we want to take some action after a cell value is changed, please use oCol:bOnChange := { |oCol, uOldValue| <any kind of action here> } Sameway oCol:bEditWhen also needs to be a silent function and return whether the ...

... on oCol:bOnPostEdit := {|o, v, n| iif( n != VK_ESCAPE, ( PA->(DBRLOCK()), FieldPut( o:nCreationOrder, v ), PA->(DBUNLOCK()) ), ) } oCol:bOnChange := { || oBrw:MakeTotals(), oBrw:RefreshFooters() } it cannot save and make error on another field I have on dbf http://img854.imageshack.us/img854/5595/errct.jpg ...

... corresponding the value in the editlistbound. - Enhancement: Method Paste() now updates dependent calculated columns also by evaluation oCol:bOnChange - Enhancement: TDOLPHIN Browse: Improved compatibility with TDolphin. Appropriate bOnPostEdit block is generated internally. No need to write ...

... := aBrowse[ i, 2 ] oCol:nWidth := aBrowse[ i, 3 ] if !Empty(aBrowse[ i, 4 ]) oCol:cEditPicture:=aBrowse[ i, 4 ] Endif oCol:oDataFont := oFont oCol:bOnChange := { ||Calcolo_Riga(IN->ITQTY,IN->ITUNIT,IN->ITTAX,IN->ITDESCONT,OBRW),; oBrw:MakeTotals(), ; oBrw:RefreshFooters() } NEXT WITH ...

... i, 2 ] oCol:nWidth := aBrowse[ i, 3 ] if !Empty(aBrowse[ i, 4 ]) oCol:cEditPicture:=aBrowse[ i, 4 ] Endif oCol:oDataFont := oFontGrid oCol:bOnChange := { ||CALC(IN->ITQTY,IN->ITUNIT,IN->ITTAX,IN->ITDESCONT,OBRW),; oBrw:MakeTotals(), ; oBrw:RefreshFooters() } NEXT but it not ...

... aBrowseRb[ i, 2 ] oCol:nWidth := aBrowseRb[ i, 3 ] NEXT AEval( oRLbx:aCols, { |o| o:cEditPicture := '99,999.99', ; o:nFooterType := AGGR_SUM, ; o:bOnChange := { || oRLbx:MakeTotals(),oRLbx:RefreshFooters() } }, 2 ) oRLbx:aCols[ 7 ]:cFooter := 'Totale' oRLbx:Totale:cFooter := 'Totale' oRLbx:nStretchCol ...