Page 1 of 1

mechanism for locking records in a DBF file

Posted: Fri Apr 19, 2019 10:15 am
by mauri.menabue
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.

Re: mechanism for locking records in a DBF file

Posted: Fri Apr 19, 2019 3:43 pm
by TimStone
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.

Re: mechanism for locking records in a DBF file

Posted: Sat Apr 20, 2019 10:06 am
by Horizon
+1