PRB: Cannot Select or Edit Record from Shared Database

ID: Q88231

The information in this article applies to:

SYMPTOMS

The records displayed in a pop-up window in a shared database cannot be highlighted or edited.

CAUSE

The most likely cause of this problem is that the record in the pop-up window is locked by another user. Once FoxPro locks a record for one user, it cannot lock the same record for another user until the first lock has been released.

RESOLUTION

In an application, incorporate a routine that attempts to lock the record and informs the user when the record is already locked. Each record can be locked by only one user at a time. For more details, see the "Multiuser Programming" section of the FoxPro "Developer's Guide."

MORE INFORMATION

Testing the pop-up window with memory variables produces the desired results. However, a memory variable behaves in the same manner as a record in a stand-alone database. In this setting, sharing records between users is not an issue because neither the records of a stand-alone database nor the memory variables can be shared among users across a network.

Additional reference words: FoxDos 2.00 FLOCK() LOCK() RLOCK() SET REPROCESS KBCategory: kbprg kbprb KBSubcategory:

Last Reviewed: May 26, 1995