I am trying to run following query on IBExpert
delete from mytable where EMPID = 55 and ROLEID = 445
I am getting error:
update conflicts with concurrent updates. Concurrent transaction number is 292071.
How do I come to know which query is running behind the scenes which has acquired the lock? Is there any way in IBExpert to know that?