FiveTech Software tech support forums

... ) writes all local modifications (if any) and then discards local record buffer so record has to be read again when any field is accessed. 3. DBCOMMIT() writes all local modifications in table and index files then it sends to system or file server request to flush (write) its disk buffers ...

... family gathered around the tree to exchange gifts. Mary used the AEVAL keyword to evaluate each gift and express her gratitude. She then used the DBCOMMIT keyword to save her appreciation in her heart and the DBUSEAREA keyword to open the database table containing her own gift for her family. ...

... CUST->CITYCUST->( dbRollBack() )? CUST->CITY  Note: dbRollBak() works only when the Record Pointer is not moved and DBCOMMIT() is not executed already thanks for the reply. I will make the case: ? CUST->CITYCUST->CITY := "CHANGED"? CUST->CITYCUTS->( ...

... CUST->CITYCUST->( dbRollBack() )? CUST->CITY  Note: dbRollBak() works only when the Record Pointer is not moved and DBCOMMIT() is not executed already

... carefully. 2) RollBack does not work with DBAPPEND(). In real time applications, we need to use some work arounds. We already know the functions: dbCommit() // works on current work area and dbCommitAll() // command COMMIT. From the next version FWH provides two new functions: dbRollBack() and ...

To All

As far as updating any .dbf record ... I use goto Recno() .. that in many cases mimics dbCommit() .. goto Recno() forces the record pointer to move albeit .. back to itself.

Rick Lpkin

karinha wrote:dbCommit (), Forces Windows to record data in the field in case of a power failure, for example.

I agree.

EMG

To All I still contend that when when you finish adding or editing a record in a .dbf .. a simple Goto Recno() is just as good as dbCommit() .. because you are moving the record pointer which flushes the buffers ... Rick Lipkin Sorry. I do not agree. https://vivaclipper.wordpress.com/2014/01/17/dbcommit/ ...

To All

I still contend that when when you finish adding or editing a record in a .dbf .. a simple Goto Recno() is just as good as dbCommit() .. because you are moving the record pointer which flushes the buffers ...

Rick Lipkin

Joao, https://harbour.harbour-project.narkive.com/9YO3sx4r/speedtest-clipper-vs-xharbour-commit dbCommit() make two things: 1. write application memory buffers to file. 2. send to OS request to flush disk buffers releated to open file. The 1-st action is executed ...

... Creo recordar que el problema es que no das tiempo a que se grabe fisicamente el registro. Debes darle un instante y forzar el grabado con el DBCOMMIT(), antes de refrescar.   (cAlias)->(dbAppend(lUnLock))   If !NetErr() // Si no hay error  ...

vi tu código, por lo visto estas usando dbCommit(), sacalos todos, ese es el primer punto a corregir, esa instrucción en redes novell produce una tremenda lentitud inexplicablemente, que en forma local no se percibe, por otro lado, el xbrowse ...

... nRecords:= (cAlias)->(reccount()) For n= 1 to nRecords (cAlias)->(DbGoto(n)) IF!Occupato((cAlias)) (cAlias)->(DbDelete()) (cAlias)->(DbCommit()) (cAlias)->(DbUnlock()) ENDIF next the problem is then how recreate the index file cdx or refresh it

... de revisar y probar cada una de las opciones que me indicaron, aplique la modificacion del Codigo de " Armando Lagunas ", saque los Dbcommit() de los Do While y recupero la velocidad que tenia en Windows XP. Infinitas gracias a todos. Muchos Saludos Antonio.

tuve ese problema hace muchos años con tablas dbf. el problema es el dbcommit() sacalo del do while...endo de tu proceso y lo colocas después del enddo y antes de cerrar la tabla dbf. lo haria asi: Sele GENEFACSeek dtos(cFecha_exa)Do While (Fec_rec=dtoc(cFecha_exa).and.!eof())  ...