FiveTech Software tech support forums

Hace mas de 20 años que no uso DBF me colmaron la paciencia son muy corruptas y no saben de política :D MySql/MariaDb, es mas sencillo de lo que se piensa. yo lo haría de esta forma: #include "fivewin.ch"function Main()   LOCAL cCodigo  := "01"   LOCAL cDescrip := "T...

... )          REPLACE EMP->cNomSucEmp WITH "PRUEBA_SQL4"          EMP->( DBCOMMIT() )       ENDIFFavor indicar cual es la sintaxis correcta para este seudocodigo : para el #command, como para ...

Buen día... En la actualidad uso una metodología similar... pero lo que quiero es no tener que reescribir o generar nuevo código para cada tabla modificada... pensé el obtener las sentencias internas del commit y aprovecharlas para escribir en un solo método las actualizaciones a cualquier tabla. Gr...

There is no ADO Sql "commit" command ... instead when you complete updating all your sql table values .. you would just issue oRsTablename:Update() .. here is a small sample code on how I manage my sql values //---------------------------------Static FUNC  _Doit(cMODE,cUserId,cPassword...

Buena tarde. Requiero para proceso de migracion de DBF´S a SQL NATIVO con fivewin - mariadb, interceptar el replace al momento del ALIAS->( dbcommit() ), para poder hacer la actualizacion con sql , sobre la base de datos SQL La idea es trabajar con tablas DBF de manera temporal , y no alterar ...

... ) 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 ...