Determining if a record is locked
From: Kent Anderson <anderske_at_agcs.com>
Date: 1998/03/04
Message-ID: <34FDD353.EA3C92DC_at_agcs.com>#1/1
Date: 1998/03/04
Message-ID: <34FDD353.EA3C92DC_at_agcs.com>#1/1
[Quoted] Is there a way to tell if a record is locked without actually blocking on it?
My situation is that we have two processes acting on the same tables in a database. If the first process updates a record, then the second process's update on that record will block until the first process ends its transaction.
Is there any way for the second process to determine if the record is locked so it can put it off until later?
-- +=================================================================+Received on Wed Mar 04 1998 - 00:00:00 CET
| Kent Anderson Phone: (602) 581-4332 |
| Engineer E-mail: anderske_at_agcs.com |
| AG Communications Systems |
| Phoenix, Arizona "Expand the power of you network" |
+-----------------------------------------------------------------+
| Visit us on the web at http://www.agcs.com |
+=================================================================+