Re: MS SQL 2000, ADO and edit lock

You have to change the "timeout" value in the object. That's ok but not too
low unless you are on a local lan and it is very reliable.

You might also want to put together some code to "pretest" the lock before
you read the record. I think you can querry of the record being locked
rather and then if not, do the read.


.

Relevant Pages

  • Re: New "timeout" api, to replace callout
    ... Timer expires on active session but source of timer was just ... time has expired and it is ready to run, once its lock gets freed. ... disable or cleanup the timeout. ...
    (freebsd-arch)
  • Re: Resolving race conditions with callbacks and cancellation?
    ... callback could be called after cancel call completes. ... The callback must be to the state-machine inside the lock. ... The state is 'Eidle' and so this event causes an action routine to be called that changes the object SM state to 'EreadWithTimeout', stores N inside the object, queues the object to the timeout thread, unlocks the SM and makes the read call, where the thread driving the object gets blocked. ...
    (comp.programming.threads)
  • Re: New "timeout" api, to replace callout
    ... only ever grab the specified lock when it calls the timeout function. ... My plan is to use non-blocking grabs of the timeouts lock to get ... When a timeouts timer expires, the thread that services the timeouts ...
    (freebsd-arch)
  • runqueue locks in schedule()
    ... timers as the interface to allow timeout-based event set multiplexing. ... timeout measures virtual ... to reinstall the timer. ... On all architectures, but IA-64, it seems thet the runqueue lock is ...
    (Linux-Kernel)
  • Re: miibus + USB = problem
    ... detach, it unregisters the timeout. ... with the lock held, thus ensuring deadlock if the timeout fires after ... This is why you can't run the detach routine locked in most ... The problem with USB devices, is that the read-register process is very ...
    (freebsd-hackers)