Re: Table is in used
Try this good old way:
DO WHILE .t.
USE delivery shared && open DBF Table
IF FLOCK() && Trying to lock this file
EXIT && nobody is using it so we can exit the loop
ELSE
WAIT WINDOW "File DELIVERY.DBF is used by another station..."
TIMEOUT 3 && Give it another try in 3 seconds
ENDIF
ENDDO
Greetings Gerhard F. Gentele
"Nick" <nick@xxxxxxxxx> schrieb im Newsbeitrag
news:u0t2TqfUIHA.4440@xxxxxxxxxxxxxxxxxxxxxxx
How to determine if a table is currently using by other user?
Thank
.
Relevant Pages
- Re: __del__ pattern?
... If it fails, report error and exit. ... Try to aquire a flock on the descriptor from step 1. ... If it fails, some running process already has the lock, exit ...
(comp.lang.python) - Re: Requiring a password?
... Teach your users to lock ... >> their workstations if they don't want their mail read. ... >>> application running on the desktop then only the Outlook app will ... >>> exit and leave the session connected to the mailbox. ...
(microsoft.public.exchange.admin) - Re: Ensuring a nice clean application quit experience
... My preferred design is to have a table with a single row that contains ... the network name of the person currently connected to the database. ... there is no 100% reliable way to delete the record on exit. ... The record lock should release when Access shuts down. ...
(comp.databases.ms-access) - Re: A new Critical Section for high contention situations
... protect a queue which is pounded by a number of threads. ... enqueus and dequeues I used CRITICAL_SECTION but because of high contention ... to enter/leave), enterMUST EXIT WITHOUT BLOCKING, and the lock must ... impossible since entercould never exit in those threads, ...
(microsoft.public.win32.programmer.kernel) - Re: A new Critical Section for high contention situations
... object MUST support. ... enter/leave), enterMUST EXIT WITHOUT BLOCKING, and the lock must NOT be ... The first time enteris ... could never exit in those threads, ...
(microsoft.public.win32.programmer.kernel) |
|
