topic-42397

Antonio Linares

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

Nuevo FWH 22.10
Posted: Wed Nov 02, 2022 11:57 AM

https://forums.fivetechsupport.com/viewtopic.php?f=16&t=42395&start=0

regards, saludos

Antonio Linares
www.fivetechsoft.com

VictorCasajuana

Posts: 309

Joined: Wed Mar 28, 2018 04:38 PM

Re: Nuevo FWH 22.10
Posted: Wed Nov 02, 2022 12:07 PM

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

Enviado desde mi motorola edge 20 mediante Tapatalk

--------

¿ Y porque no ?

¿ And why not ?

Antonio Linares

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

Re: Nuevo FWH 22.10
Posted: Wed Nov 02, 2022 12:11 PM

Estimado Victor,

Es Mr. Rao quien nos tiene que responder tu pregunta :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Nuevo FWH 22.10
Posted: Wed Nov 02, 2022 03:59 PM

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 (fw): Select all Collapse

? 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

Regards

G. N. Rao.

Hyderabad, India

VictorCasajuana

Posts: 309

Joined: Wed Mar 28, 2018 04:38 PM

Re: Nuevo FWH 22.10
Posted: Wed Nov 02, 2022 04:39 PM

nageswaragunupudi 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 (fw): Select all Collapse
? 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 (fw): Select all Collapse

? 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" ?

--------

¿ Y porque no ?

¿ And why not ?

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Nuevo FWH 22.10
Posted: Wed Nov 02, 2022 06:42 PM

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
https://forums.fivetechsupport.com/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.

Regards

G. N. Rao.

Hyderabad, India

VictorCasajuana

Posts: 309

Joined: Wed Mar 28, 2018 04:38 PM

Re: Nuevo FWH 22.10
Posted: Thu Nov 03, 2022 09:42 AM

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
https://forums.fivetechsupport.com/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!

--------

¿ Y porque no ?

¿ And why not ?

FiveTech Support Forums

Continue the discussion