FiveTech Software tech support forums

Hola Antonio, dbRollBack() funciona en entornos de red con DBF?

Enviado desde mi motorola edge 20 mediante Tapatalk

Estimado Victor,

Es Mr. Rao quien nos tiene que responder tu pregunta

VictorCasajuana wrote:Hola Antonio, dbRollBack() funciona en entornos de red con DBF?

Enviado desde mi motorola edge 20 mediante Tapatalk

It should work.
Can you help is by testing?

E.g. customer.dbf opened with alias CUST

Code: Select all  Expand view

? CUST->CITY
CUST->CITY := "CHANGED"
? CUST->CITY
CUST->( dbRollBack() )
? CUST->CITY
 

Note: dbRollBak() works only when the Record Pointer is not moved and DBCOMMIT() is not executed already

nageswaragunupudi wrote:

VictorCasajuana wrote:Hola Antonio, dbRollBack() funciona en entornos de red con DBF?

Enviado desde mi motorola edge 20 mediante Tapatalk

It should work.
Can you help is by testing?

E.g. customer.dbf opened with alias CUST

Code: Select all  Expand view

? CUST->CITY
CUST->CITY := "CHANGED"
? CUST->CITY
CUST->( 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:

Code: Select all  Expand view

? CUST->CITY
CUST->CITY := "CHANGED"
? CUST->CITY
CUTS->( DbUnlock() )  
// do other process...
CUST->( dbRollBack() )
? CUST->CITY
 

Taking into account that CUST->CITY has the value: "ORIGINAL"
if after making the change to "CHANGED" and doing the dbunlock, if before the dbrollback() another user modifies the value of CUST->CITY by "OTHER USER"
when the rollback() is performed, what value will CUST->CITY finally have, "ORIGINAL" or "OTHER USER" ?

After doing unlock also, dbrollback does not work
Rollback works before (1) moving record pointer (2) before commit and also (3) before unlock.

This is useful for making modifications in more than one dbf and ensure that either all changes are committed or rolledback.

Please refer
viewtopic.php?f=3&t=42174&p=253200&hilit=dbrollback&sid=e912045ef71b285d5d2193725aa93ffe#p253200

You may post further queries in that post so that all users will join.

nageswaragunupudi wrote:After doing unlock also, dbrollback does not work
Rollback works before (1) moving record pointer (2) before commit and also (3) before unlock.

This is useful for making modifications in more than one dbf and ensure that either all changes are committed or rolledback.

Please refer
viewtopic.php?f=3&t=42174&p=253200&hilit=dbrollback&sid=e912045ef71b285d5d2193725aa93ffe#p253200

You may post further queries in that post so that all users will join.

thanks for the clarification!