Microsoft KB Archive/179294

= FIX: Record In Use Message Editing in Browse and Using Find Dialog Box =

Article ID: 179294

Article Last Modified on 5/10/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0b for Macintosh
 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a

-



This article was previously published under Q179294



SYMPTOMS
When you Browse a table and use the Find dialog box to locate records for editing, the following error message appears when you are editing records:

Record is in use by another user.



CAUSE
This behavior occurs under the three following conditions:


 * A table has been opened for browsing with buffering enabled.

-or-
 * The Find dialog box (CTRL-F) is used to locate records for editing.

-or-
 * Successive records are found and then edited.



RESOLUTION
Here are three workarounds for this behavior:


 * Move the record pointer off an edited record before finding the next record.

-or-
 * Use the default buffering mode.

-or-
 * Use a SEEK or LOCATE command.



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This has been corrected in Visual FoxPro 6.0.



MORE INFORMATION
This behavior occurs after buffering has been enabled. After the "Record is in use by another user" message appears, subsequent attempts to edit the record continue to fail regardless of the buffering mode until the table is closed and reopened. This behavior does not occur if the record pointer is moved off the edited record (via the keyboard or mouse) before finding the next record. Likewise, a record where the error has occurred can be successfully edited if you move the record pointer off and back onto the record.

Steps to Reproduce Behavior
  In the FoxPro Command window, type the following commands: USE HOME+"\samples\data\customer" SET MULTILOCKS ON     =CURSORSETPROP('BUFFERING',2,'customer') BROWSE  Press CTRL+F to open the Find dialog box. Enter ANATR, and then click Find Next. Press escape and edit the record. Press CTRL+F to open the Find dialog box. Enter ANTON, and then click Find Next. Press escape and edit the record.

When the second record is edited, the following error message appears:

Record is in use by another user.

</li></ol> </li> Click the OK button and then press the escape key to return to the FoxPro Command window.</li>  From the Command window type the following commands: =CURSORSETPROP('BUFFERING',1,'customer') BROWSE Attempt to edit the record. </li></ol>

Keywords: kbbug kbfix kbvfp600fix kbprb KB179294

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.