Subject | Deadlock question |
---|---|
Author | Robert martin |
Post date | 2006-04-10T04:41:30Z |
Hi
If I run the following SQL from two applications / threads
simultaneously should I get a deadlock (Where aPK is the same record)?
UPDATE aTable SET Qty = Qty + :Qty WHERE aPK = :aPK;
--
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
If I run the following SQL from two applications / threads
simultaneously should I get a deadlock (Where aPK is the same record)?
UPDATE aTable SET Qty = Qty + :Qty WHERE aPK = :aPK;
--
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd