FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour ADD oCol TO XBROWSE...
Posts: 2170
Joined: Fri Jul 18, 2008 01:24 AM
ADD oCol TO XBROWSE...
Posted: Sat Apr 23, 2016 03:44 AM
Saludos, amigos del foro.
Code (fw): Select all Collapse
REDEFINE XBROWSE oBrw2 ID 182 OF oWndChild ;
            AUTOCOLS SIZES 20,60,80,340 ALIAS "CTXCOB" CELL LINES

   ADD oCol TO oBrw2 AT 4 DATA 0.00 SIZE 80 HEADER "PAGO"

   oBrw2:bGotFocus:= {|| dbselectarea("CTXCOB") }
   oBrw2:bKeyDown := {|nKey| GrabPagos(nKey,oBrw2) }

*****
Luego en la function GrabPagos():

//-----------------------------
Function GrabPagos(nKey,oBrw)

if nKey == 32   //VK_SPACE
   oBrw:Pago:Value := oBrw:SaldoAct:Value   //NO ME FUNCIONA...  ES LA COLUMNA AGREGADA (ADD  oCol...)
   //oBrw:Value := oBrw:Value   //Esta si funciona
   oBrw:Refresh()
endif
Return nil


¿Por qué no funciona?... ¿Alguna pista?

Gracias.

Saludos.
Francisco J. Alegría P.

Chinandega, Nicaragua.



Fwxh-MySql-TMySql
Posts: 2170
Joined: Fri Jul 18, 2008 01:24 AM
Re: ADD oCol TO XBROWSE...
Posted: Sun Apr 24, 2016 12:42 AM

Bueno, opté por utilizar un campo de la tabla.
Saludos.

Francisco J. Alegría P.

Chinandega, Nicaragua.



Fwxh-MySql-TMySql
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: ADD oCol TO XBROWSE...
Posted: Sun Apr 24, 2016 12:53 PM
sample:
Code (fw): Select all Collapse
#include "fivewin.ch"

function main()

   local oDlg, oBrw, oFont
   local aData

   USE CUSTOMER

   aData    := Array( CUSTOMER->( LASTREC() ) )
   AFILL( aData, 0.00 )

   DEFINE FONT oFont NAME "TAHOMA" SIZE 0,-14
   DEFINE DIALOG oDlg SIZE 500,500 PIXEL TRUEPIXEL FONT oFont

   @ 20,10 XBROWSE oBrw SIZE -20,-20 PIXEL OF oDlg ;
      DATASOURCE "CUSTOMER" ;
      COLUMNS "FIRST", "SALARY" ;
      CELL LINES NOBORDER FOOTERS

   ADD TO oBrw ;
      DATA { |x,o| If( x == nil, aData[ o:oBrw:BookMark ], aData[ o:oBrw:BookMark ] := x ) } ;
      HEADER "NewCol"

   WITH OBJECT oBrw
      :Salary:nFooterType     := AGGR_SUM
      :NewCol:nFooterType     := AGGR_SUM
      :NewCol:nWidth          := 100
      :bKeyChar   := { |nKey| If( nKey == 32, ;
                       oBrw:NewCol:VarPut( If( Empty( oBrw:NewCol:Value ), ;
                        oBrw:Salary:Value, 0.00 ) ), nil ) }
      //
      :MakeTotals()
      :CreateFromCode()
   END

   ACTIVATE DIALOG oDlg CENTERED
   RELEASE FONT oFont

return nil
Regards



G. N. Rao.

Hyderabad, India
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: ADD oCol TO XBROWSE...
Posted: Sun Apr 24, 2016 01:10 PM
Another simple way
Code (fw): Select all Collapse
#include "fivewin.ch"

function main()

   local oDlg, oBrw, oFont
   local aData

   USE CUSTOMER

   aData    := Array( CUSTOMER->( LASTREC() ) )
   AFILL( aData, 0.00 )

   DEFINE FONT oFont NAME "TAHOMA" SIZE 0,-14
   DEFINE DIALOG oDlg SIZE 500,500 PIXEL TRUEPIXEL FONT oFont

   @ 20,10 XBROWSE oBrw SIZE -20,-20 PIXEL OF oDlg ;
      DATASOURCE "CUSTOMER" ;
      COLUMNS "FIRST", "SALARY", { || aData[ RECNO() ] } ;
      HEADERS  nil, nil, "NewCol" ;
      CELL LINES NOBORDER


   WITH OBJECT oBrw
      :NewCol:nWidth          := 100
      :bKeyChar   := { |nKey| If( nKey == 32, ;
         ( aData[ CUSTOMER->( RECNO() ) ] := CUSTOMER->SALARY, ;
           oBrw:RefreshCurrent() ), nil ) }

      //
      :MakeTotals()
      :CreateFromCode()
   END

   ACTIVATE DIALOG oDlg CENTERED
   RELEASE FONT oFont

return nil
Regards



G. N. Rao.

Hyderabad, India
Posts: 2170
Joined: Fri Jul 18, 2008 01:24 AM
Re: ADD oCol TO XBROWSE...
Posted: Sun Apr 24, 2016 06:13 PM
Thanks, Mr. Rao
Code (fw): Select all Collapse
 WITH OBJECT oBrw
      :Salary:nFooterType     := AGGR_SUM
      :NewCol:nFooterType     := AGGR_SUM
      :NewCol:nWidth          := 100
      :bKeyChar   := { |nKey| If( nKey == 32, ;
                       oBrw:NewCol:VarPut( If( Empty( oBrw:NewCol:Value ), ;
                        oBrw:Salary:Value, 0.00 ) ), nil ) }
      //
      :MakeTotals()
      :CreateFromCode()
   END

Best regards
Francisco J. Alegría P.

Chinandega, Nicaragua.



Fwxh-MySql-TMySql

Continue the discussion