Microsoft KB Archive/124865

{| = PRB: "Record is not locked" When Editing Multi-table Browse =
 * width="100%"|

ID: Q124865

2.60a  | 2.60a WINDOWS | MS-DOS The information in this article applies to:


 * Microsoft FoxPro for Windows, version 2.6a
 * Microsoft FoxPro for MS-DOS, version 2.6a

SYMPTOMS
When editing the data in a Browse window using the BROWSE command with the FIELDS clause, where the fields come from more than one table, a dialog box appears containing the message:

Record is not locked

CAUSE
One or more of the tables whose fields are included in the BROWSE is opened exclusively.

One cause of the "Record is not locked" message is attempting to edit any field of a multi-table BROWSE involving related tables when one of the tables is opened for exclusive use.

RESOLUTION
Do not open any of the tables exclusively, or edit the fields within the @ ... GET fields of a window defined by FoxPro's Screen Builder.

STATUS
This behavior is by design.

MORE INFORMATION
Steps to Reproduce Behavior

1. Set the default directory to the TUTORIAL directory provided with the

product by typing the following in the Command window:

SET DEFAULT TO SYS(2004)+ "tutorial" 2. Create and run a program containing the following commands: CLOSE ALL USE detail EXCLUSIVE && Open the file exclusively INDEX ON pno TAG pno && If the tag already exists, reply YES CLOSE ALL           && Remove exclusive setting SET EXCLUSIVE OFF USE parts EXCLUSIVE && EXCLUSIVE will cause the message USE detail IN 0 ORDER TAG pno SELECT parts SET RELATION TO pno INTO detail BROWSE FIELDS parts.pno, detail.price 3. Move the insertion point to the PRICE field of any record and enter some new data, including two digits to the right of the decimal point. The message "Record is not locked" appears. This happens on a single-user system and on a shared (network) system, with or without multi-locks being set on or off, and with or without the Detail table being opened in Shared mode. This occurs because FoxPro assigns Exclusive status to the browsed data of all of the related tables when one of those tables is opened exclusively.

Additional reference words: 2.60a FoxWin FoxDos errmsg multiuser network KBCategory: KBSubcategory: FxprgMultiuser

Keywords         : kberrmsg FxprgMultiuser Version          : 2.60a | 2.60a Platform         : MS-DOS WINDOWS
 * }