Nuevo FWH 22.10

Post Reply
User avatar
Antonio Linares
Site Admin
Posts: 42643
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Has thanked: 59 times
Been thanked: 93 times
Contact:

Nuevo FWH 22.10

Post by Antonio Linares »

regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
VictorCasajuana
Posts: 269
Joined: Wed Mar 28, 2018 4:38 pm
Location: Vinaròs
Has thanked: 1 time
Contact:

Re: Nuevo FWH 22.10

Post by VictorCasajuana »

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

Enviado desde mi motorola edge 20 mediante Tapatalk
--------
¿ Y porque no ?
¿ And why not ?
User avatar
Antonio Linares
Site Admin
Posts: 42643
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain
Has thanked: 59 times
Been thanked: 93 times
Contact:

Re: Nuevo FWH 22.10

Post by Antonio Linares »

Estimado Victor,

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

Antonio Linares
www.fivetechsoft.com
User avatar
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 10 times
Contact:

Re: Nuevo FWH 22.10

Post by nageswaragunupudi »

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

? 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
User avatar
VictorCasajuana
Posts: 269
Joined: Wed Mar 28, 2018 4:38 pm
Location: Vinaròs
Has thanked: 1 time
Contact:

Re: Nuevo FWH 22.10

Post by VictorCasajuana »

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

? 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

? 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 ?
User avatar
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 10 times
Contact:

Re: Nuevo FWH 22.10

Post by nageswaragunupudi »

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/view ... fe#p253200

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

G. N. Rao.
Hyderabad, India
User avatar
VictorCasajuana
Posts: 269
Joined: Wed Mar 28, 2018 4:38 pm
Location: Vinaròs
Has thanked: 1 time
Contact:

Re: Nuevo FWH 22.10

Post by VictorCasajuana »

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/view ... fe#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 ?
Post Reply