<div>
It's like asking what is the best way to use a kitchen.<br />
<br />
The topic locking is a bit narrower, still if you ask this question without telling what you expect of locking and how your application should work, you better first read about what locking can do for.<br />
<br />
First of all locks are only needed for multi user environments. Is your dos app multi user at all?<br />
<br />
Bye, Olaf.
</div>


It's like asking what is the best way to use a kitchen.

The topic locking is a bit narrower, still if you ask this question without telling what you expect of locking and how your application should work, you better first read about what locking can do for.

First of all locks are only needed for multi user environments. Is your dos app multi user at all?

Bye, Olaf.

<div>
The usual approach to locking a single record:<br />
<br />

<pre><code id="code-20-39637830-1">IF RLOCK('table')
    DO stuff
    UNLOCK IN table
ELSE
    WAIT WINDOW &quot;Record is locked by another user&quot;.
ENDIF</code></pre>
</div>


The usual approach to locking a single record:



IF RLOCK('table')
    DO stuff
    UNLOCK IN table
ELSE
    WAIT WINDOW "Record is locked by another user".
ENDIF

<div>
<div class="content wysiwyg-content">
I have been asked about record and file locking in Foxpro for DOS 2.6. What would be the best way to approach record locking for record writes/updates? What about file locking?
</div>
</div>


I have been asked about record and file locking in Foxpro for DOS 2.6. What would be the best way to approach record locking for record writes/updates? What about file locking?

Foxpro for DOS 2.6 record locking

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.