FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour mechanism for locking records in a DBF file
Posts: 181
Joined: Thu Apr 17, 2008 02:38 PM
mechanism for locking records in a DBF file
Posted: 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.

Posts: 3022
Joined: Fri Oct 07, 2005 01:45 PM
Re: mechanism for locking records in a DBF file
Posted: Fri Apr 19, 2019 03: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
Posts: 1387
Joined: Fri May 23, 2008 01:33 PM
Re: mechanism for locking records in a DBF file
Posted: Sat Apr 20, 2019 10:06 AM

+1

Regards,



Hakan ONEMLI



Harbour & MSVC 2022 & FWH 23.06

Continue the discussion