Jump to content
Fivewin Brasil

Spirin's fastreport library


kapiaba

Recommended Posts

Função interessante nos exemplos da FASTREPORT no final.

FUNCTION INDEXAR()
	   /* Exemplo by Spirin Sergey
   IF ! AllFilesExist( { "CUSTA.NTX", "CUSTB.NTX" } )
      USE Customer EXCLUSIVE
      INDEX ON CustNo  TO CustA
      INDEX ON Company TO CustB
      CLOSE
   ENDIF
   */
	   AEVAL(DIRECTORY( "CADPROPO.cdx" ),{ |aFILE| FERASE(aFILE[F_NAME]) } )
	   IF .NOT. AllFilesExist( { "CADPROPO.cdx" } )
	      USE CADPROPO NEW EXCLUSIVE ALIAS CADPROPO
	      oMeter1:nTotal = RecCount()
	      INDEX ON VAL(Field->PROPOCOD) TAG PROPOCOD TO CADPROPO            ;
            FOR !DELETED()                                              ;
            EVAL ( oMeter1:Set( RecNo() ), CursorWait(), SysRefresh() ) ;
            EVERY 10
	      INDEX ON Field->CONTRCOD TAG CONTRCOD TO CADPROPO                 ;
            FOR !DELETED()                                              ;
            EVAL ( oMeter1:Set( RecNo() ), CursorWait(), SysRefresh() ) ;
            EVERY 10
	      INDEX ON Field->CLIENCOD TAG CLIENCOD TO CADPROPO                 ;
            FOR !DELETED()                                              ;
            EVAL ( oMeter1:Set( RecNo() ), CursorWait(), SysRefresh() ) ;
            EVERY 10
	      INDEX ON Field->CLIENTE  TAG CLIENTE  TO CADPROPO                 ;
            FOR !DELETED()                                              ;
            EVAL ( oMeter1:Set( RecNo() ), CursorWait(), SysRefresh() ) ;
            EVERY 10
	      INDEX ON Field->END_PROP TAG ENDERECO TO CADPROPO                 ;
            FOR !DELETED()                                              ;
            EVAL ( oMeter1:Set( RecNo() ), CursorWait(), SysRefresh() ) ;
            EVERY 10
	      CLOSE DATABASE
	   ENDIF
	RETURN NIL
///////////////////////////////////////////////////////////////////////
// Verify if the files in 'aFiles' vector exist                      //
///////////////////////////////////////////////////////////////////////
FUNCTION AllFilesExist( aFiles )
	   local lExist := .T., i:=0, imax := len(aFiles)
	   do while ++i <= imax .and. lExist
	      SysRefresh()
	      lExist := File( aFiles[i] )
	   enddo
	RETURN lExist

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...