Hello Group,

Can someone please explain to me the difference between the following
exceptions raised by Firebird?

---
lock conflict on no wait transaction
violation of FOREIGN KEY constraint "FK_BAR" on table "FOO"
---

and

---
deadlock
update conflicts with concurrent update
---

I know that the parent record exists for the first case (unless my
problem is deeper than I suspect). Is it complaining rather about the
fact that a different transaction may be simultaneously updating the
parent record (although definately not touching the primary key field)?

Thanks in advance

Adam