How does CodeBase (Sequiter) make locks?
Posted on 2004-04-27
I am using CodeBase - package of program from Sequiter Software, Inc to manage
dB and FoxPro database tables.
They provide C-source code for this package, but I don't have time to read it.
Does anyone knows the principal method CodeBase (CB) uses to lock record or
an entire table (table is a file, usually with extension .dbf).
In our Microsoft Windows network, users use
CodeBase 6.3, Stand-alone(no client-server achitecture).
They have common database files on single network computer.
In other words, this network computer and files, (.dbf, fpt, cdx)
are shared between users.
All applications written in Microsoft Visual Basic and use C4fox.dll
All questions below asked for this architecture.
What is a principal mechanism to lock record and lock database file?
Does CB writes an additional file next to database file and this
additional file contains number (reference) of the locked record or marker for
locked file? When record is unlocked, this number is removed, is this correct?
(I never noticed any extra files in Windows Explorer though, perhaps changes go too fast?)