Didn't mean to get under your skin, Jason, but you did say -

"One thing that might be possible is to use a trigger and external tables to
examine what records are locked and by whom. If a deadlock occurs you could
scan through the external table for the most recent occurrence of the
locked
record and who has it locked."

What I was looking for was the API call needed to be made in order to find
out
who has what record locked in what table? I was not questioning your
knowledge
on the subject.

Regards,
Dion.

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: 10 January 2001 06:43
To: IBObjects@egroups.com
Subject: Re: [IBO] Getting Username from deadlock error

> Does naybody know the API(if this is the way) call to get a username in

the

> case of a locked record?

I said this is not possible. What more do I need to say?

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com