Subject | How to handle a deadlock |
---|---|
Author | Christian Gütter |
Post date | 2001-02-01T14:58:43Z |
Hi,
I have written an application
which completely updates a small
table when it starts.
So there is a high risk that a deadlock
occurs when another user is also updating
this table.
Because this is a routine which executes
automatically I don't want to confuse the
users with deadlock messages.
So I wonder how to hide such a message.
It should be work like:
if Error = deadlock
then
begin
DoThis;
DontDisplayMessage;
end;
I know the code above looks quite funny and
naive, but I guess it shows very clearly what
I want to accomplish.
I have had a look at IB_Header.pas and IB_Session.pas,
but I couldn't figure out how to do it.
(Anyway, I think having a look at IB error handling
is generally worth a lot ;-)
TIA,
Christian
I have written an application
which completely updates a small
table when it starts.
So there is a high risk that a deadlock
occurs when another user is also updating
this table.
Because this is a routine which executes
automatically I don't want to confuse the
users with deadlock messages.
So I wonder how to hide such a message.
It should be work like:
if Error = deadlock
then
begin
DoThis;
DontDisplayMessage;
end;
I know the code above looks quite funny and
naive, but I guess it shows very clearly what
I want to accomplish.
I have had a look at IB_Header.pas and IB_Session.pas,
but I couldn't figure out how to do it.
(Anyway, I think having a look at IB error handling
is generally worth a lot ;-)
TIA,
Christian