mechanism for locking records in a DBF file

mechanism for locking records in a DBF file

Postby mauri.menabue » Fri Apr 19, 2019 10:15 am

Good morning

I would like to have clarifications regarding the mechanism for locking records in a DBF file.
Based on the lock scheme
DBFLOCK_DEFAULT 0
DBFLOCK_CLIP 1
DBFLOCK_CL53 2
DBFLOCK_VFP 3
DBFLOCK_CL53EXT 4
DBFLOCK_XHB64 5
are seen as different Loked records,
is the list of locked records memorized in the file header?
How can you reset the list of locked records?
It happens that due to network disconnections I still have files
with record locked while closing and reopening the file.

Thanks all.
User avatar
mauri.menabue
 
Posts: 155
Joined: Thu Apr 17, 2008 2:38 pm

Re: mechanism for locking records in a DBF file

Postby TimStone » Fri Apr 19, 2019 3:43 pm

I have always understood record locking was stored in memory on the server. So I simply have clients re-boot the server and all is well.

I keep intending to explore a better solution to this.
Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
User avatar
TimStone
 
Posts: 2945
Joined: Fri Oct 07, 2005 1:45 pm
Location: Trabuco Canyon, CA USA

Re: mechanism for locking records in a DBF file

Postby Horizon » Sat Apr 20, 2019 10:06 am

+1
Regards,

Hakan ONEMLI

Harbour & MSVC 2022 & FWH 23.04
Horizon
 
Posts: 1322
Joined: Fri May 23, 2008 1:33 pm


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 41 guests