And, of course, connecting with Multi OFF clears all Table and Row Locks.
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Tuesday, January 16, 2007 3:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Clearing Ghost Connections, and other stuff << Now the question is......when does it not work? >> My guess is "when the operating system reports another lock on the file". I believe what's happening is that when you start R:Base it checks the file to see if it can get an exclusive write lock. If it can, it locks the file, opens it, performs "maintenance", closes it, then reopens it in shared write mode. If the operating system "believes" a lock exists on the file the exclusive write will fail and R:Base will act as if it's in multi-user mode (which it really is). Using SET MULTI OFF before you connect will alert you to situations in which you _think_ you're the only user in the database, but the operating system says otherwise. -- Larry
