Nuevo FWH 22.10

Nuevo FWH 22.10

Postby Antonio Linares » Wed Nov 02, 2022 11:57 am

regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 41366
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Nuevo FWH 22.10

Postby VictorCasajuana » 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 ?
User avatar
VictorCasajuana
 
Posts: 197
Joined: Wed Mar 28, 2018 4:38 pm
Location: Vinaròs

Re: Nuevo FWH 22.10

Postby Antonio Linares » 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
User avatar
Antonio Linares
Site Admin
 
Posts: 41366
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Nuevo FWH 22.10

Postby nageswaragunupudi » Wed Nov 02, 2022 3: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: 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
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10295
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Nuevo FWH 22.10

Postby VictorCasajuana » Wed Nov 02, 2022 4:39 pm

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" ?
--------
¿ Y porque no ?
¿ And why not ?
User avatar
VictorCasajuana
 
Posts: 197
Joined: Wed Mar 28, 2018 4:38 pm
Location: Vinaròs

Re: Nuevo FWH 22.10

Postby nageswaragunupudi » Wed Nov 02, 2022 6: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
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
User avatar
nageswaragunupudi
 
Posts: 10295
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Nuevo FWH 22.10

Postby VictorCasajuana » Thu Nov 03, 2022 9: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
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 ?
User avatar
VictorCasajuana
 
Posts: 197
Joined: Wed Mar 28, 2018 4:38 pm
Location: Vinaròs


Return to FiveWin para Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 45 guests