FiveTech Software tech support forums

... to the RowSet()
oRs:CancelBatch()

Batch mode continues till we reset.
oRs:SetBatchMode( .f. )

IMPORTANT CAUTION:
Even in lBatchMode, METHOD Zap() really Zaps the table in the database.
Please do not use it.

So for your requirements use BatchMode
oRs := oCn:RowSet( ........... )
oRs ...

... en sistemas sql : requestApi,,, donde estos objetos en memoria los manipulamos, y ya en otra lógica afectamos a la base de datos...

Ejp : ojeto:zap()... se elimina la tabla... en la logica... un zap sobre datos reales, es un caso muy especial y de mucho control... pero un zap sobre temporales si ...

... oRs:Append( { "name", "salary" }, { "Anderson", 30000 } )
METHOD Update( aFields, aValues ) --> lSuccess
METHOD Delete() --> lSuccess
METHOD Zap()

no afecten a la base de datos.. que solo solo afecten al recordSet---


La idea es usar bien sea un objeto TArrayData() o RowSet() para migrar de ...

... always use 2 DBF editors: the one by Enrico and the one by Franklin.

Enrico's for quick lookup and browsing and for changing the structure, ZAP, PACK. It runs rock solid. Unfortunately, some functions are missing, like statistics, replace, etc.

Please elaborate: which functions are missing ...

... always use 2 DBF editors: the one by Enrico and the one by Franklin.

Enrico's for quick lookup and browsing and for changing the structure, ZAP, PACK. It runs rock solid. Unfortunately, some functions are missing, like statistics, replace, etc.

Since structure changes didn't start at all in ...

... always use 2 DBF editors: the one by Enrico and the one by Franklin.

Enrico's for quick lookup and browsing and for changing the structure, ZAP, PACK. It runs rock solid. Unfortunately, some functions are missing, like statistics, replace, etc.

Since structure changes didn't start at all in ...

... COMUNES\logrdd.prg(404) Error E0059 Invalid SWITCH Constant 'DELETE'.
FUENTES\COMUNES\logrdd.prg(407) Error E0059 Invalid SWITCH Constant 'RECALL'.
FUENTES\COMUNES\logrdd.prg(410) Error E0059 Invalid SWITCH Constant 'PUTVALUE'.
FUENTES\COMUNES\logrdd.prg(414) Error E0059 Invalid SWITCH Constant 'ZAP'.

... ProvFor index ProvFor1, ProvFor2 new
use ArtFor index ArtFor1, ArtFor2, ArtFor3, ArtFor4, ArtFor5 new
use _ArtFor index _ArtFor1, _ArtFor2 new
zap
select ArtFor
ArtFor->(DbGoTop())
While !ArtFor->(Eof())
select _ArtFor
_ArtFor->(DbAppend())
_ArtFor->Articulo := ArtFor->Articulo
_ArtFor ...

... pregunta ¿ Cual es el motivo por el que el otro proceso tiene el archivo abierto en exclusividad ?

Ejemplo:

USE BANCO EXCLUSIVE NEW

INDEX ON..
ZAP
APPEND FROM..

etc

Lea el manual de Clipper, Harbour o xHarbour, por favor.

https://vivaclipper.wordpress.com/2014/02/17/use/

Regards, saludos.