FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour SHOW A SIMPLY XBROWSE
Posts: 7318
Joined: Thu Oct 18, 2012 07:17 PM
SHOW A SIMPLY XBROWSE
Posted: Sun Apr 28, 2013 10:11 PM
i need to open a xbrowse into a dialog and I must take the fields and titles from an array


aCampi:={CLIENTI->CODCF,CLIENTI->RAGSOC ,CLIENTI->RAGSOC1,CLIENTI->INDIR }
aNomi:={"Codice","Ragione Sociale","Ragione Sociale2","Indirizzo Legale"}
aSizes:= {50,250 ,200,100 }





the test run but it not show the records

Code (fw): Select all Collapse
#Include "Fivewin.ch"
#include 'xbrowse.ch'
#include "constant.ch"


Function Test()

   Local nBottom   := 35.7
   Local nRight    := 105
   Local nWidth :=  Max( nRight * DLG_CHARPIX_W, 180 )
   Local nHeight := nBottom * DLG_CHARPIX_H
   Local oDlg
   Local oBrw
   local oCol
    local aBrowse:={ },i,k

     USE CLIENTI  ALIAS CLIENTI NEW


     aCampi:={CLIENTI->CODCF,CLIENTI->RAGSOC ,CLIENTI->RAGSOC1,CLIENTI->INDIR  }
     aNomi:={"Codice","Ragione Sociale","Ragione Sociale2","Indirizzo Legale"}
     aSizes:= {50,250 ,200,100  }

  FOR k := 1 TO Len(aCampi)
             AADD(  aBrowse,{aCampi[k],aNomi[k],aSizes[k]})
         NEXT


      DEFINE DIALOG oDlg        ;
   TITLE "test with xbrowse "   ;
   SIZE nWidth, nHeight 



     @ 15.6, 0 XBROWSE  oBrw OF oDlg ;
      SIZE -1,-20 PIXEL


     
  FOR i := 1 TO Len(aBrowse)
      oCol := oBrw:AddCol()
       oCol:bEditValue := aBrowse[ i, 1 ]
       oCol:cHeader  := aBrowse[ i, 2 ]
      oCol:nWidth   := aBrowse[ i, 3 ]
    
   NEXT


      oBrw:SetRDD()
      oBrw:CreateFromCode()


      ACTIVATE DIALOG oDlg center


      RETURN NIL
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: SHOW A SIMPLY XBROWSE
Posted: Sun Apr 28, 2013 11:28 PM
Code (fw): Select all Collapse
#Include "Fivewin.ch"
#include 'xbrowse.ch'
#include "constant.ch"


Function Test()

   Local nBottom   := 35.7
   Local nRight    := 105
   Local nWidth :=  Max( nRight * DLG_CHARPIX_W, 180 )
   Local nHeight := nBottom * DLG_CHARPIX_H
   Local oDlg
   Local oBrw
   local oCol
   local aBrowse:={ },i,k

   USE CLIENTI  ALIAS CLIENTI NEW


//   aCampi:={CLIENTI->CODCF,CLIENTI->RAGSOC ,CLIENTI->RAGSOC1,CLIENTI->INDIR  } // see next line
   aCampi := { "CODCF", "RAGSOC", "RAGSOC1", "INDIR" } // Field names in quotes : GNR
   aNomi:= {"Codice","Ragione Sociale","Ragione Sociale2","Indirizzo Legale"}
   aSizes:= {50,250 ,200,100  }

/*
  // not necessary
  
  FOR k := 1 TO Len(aCampi)
             AADD(  aBrowse,{aCampi[k],aNomi[k],aSizes[k]})
         NEXT
*/


   DEFINE DIALOG oDlg TITLE "test with xbrowse " SIZE nWidth, nHeight 

   @ 15.6, 0 XBROWSE  oBrw OF oDlg SIZE -1,-20 PIXEL ; // next lines added by GNR
      DATASOURCE "CLIENTI" ; // Very Important. Never forget this
      COLUMNS aCampi ;
      HEADERS aNomi ;
      COLSIZES aSizes 

/*
  // Not this way. We already included this info correctly in the Xbrowse statement
     
  FOR i := 1 TO Len(aBrowse)
      oCol := oBrw:AddCol()
       oCol:bEditValue := aBrowse[ i, 1 ]
       oCol:cHeader  := aBrowse[ i, 2 ]
      oCol:nWidth   := aBrowse[ i, 3 ]
    
   NEXT
*/

//      oBrw:SetRDD()  // Omit this. XBrowse DATASOURCE clause already called SetRDD()

      oBrw:CreateFromCode()


      ACTIVATE DIALOG oDlg center


      RETURN NIL


Final code
Code (fw): Select all Collapse
#Include "Fivewin.ch"
#include 'xbrowse.ch'

Function Test()

   Local nBottom   := 35.7
   Local nRight    := 105
   Local nWidth :=  Max( nRight * DLG_CHARPIX_W, 180 )
   Local nHeight := nBottom * DLG_CHARPIX_H
   Local oDlg, oBrw

   USE CLIENTI  ALIAS CLIENTI NEW

   aCampi := { "CODCF", "RAGSOC", "RAGSOC1", "INDIR" } // Field names in quotes : GNR
   aNomi:= {"Codice","Ragione Sociale","Ragione Sociale2","Indirizzo Legale"}
   aSizes:= {50,250 ,200,100  }

   DEFINE DIALOG oDlg TITLE "test with xbrowse " SIZE nWidth, nHeight 

   @ 15.6, 0 XBROWSE  oBrw OF oDlg SIZE -1,-20 PIXEL ; 
      DATASOURCE "CLIENTI" ; // Very Important. Never forget this
      COLUMNS aCampi  HEADERS aNomi  COLSIZES aSizes 

   oBrw:CreateFromCode()

   ACTIVATE DIALOG oDlg center

   RETURN NIL
Regards



G. N. Rao.

Hyderabad, India
Posts: 7318
Joined: Thu Oct 18, 2012 07:17 PM
Re: SHOW A SIMPLY XBROWSE
Posted: Mon Apr 29, 2013 08:01 AM

Thanks Mr. Rao

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Continue the discussion