Is there a way to determine WHO has a Row, Cursor or Table lock on a table? Is there a way to remove a lock, if needed?
There have been some cases where a user puts on a table lock (set lock xxxxx on) and their computer crashes and the lock remains. The only way I found to remove this "bad" lock is to wait until everyone has exited the database. Usually it is the table lock that is the problem but today I had a client that had a "row lock" on a table but no one was using that table. They said that the computer crashed shortly? after they got out of the form. Why would it retain the row lock? Ran MONITR and it said that there was 1 Concurrent user and it had an Edit or Row lock on the table. Some settings are Set Qualcols 2 and Set Rowlocks ON. Running RB6.5++ DOS on Win2000 computer Frank Radice [EMAIL PROTECTED]
