Hi All,

Does naybody know the API(if this is the way) call to get a username in the
case of a locked record?

Thanks,
Dion.



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

> Is it possible to get a user name, IP address etc using IBO when an error
> occurs(eg deadlock).

No, this is something that I hope is added very soon.

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.

External tables are outside of transaction control so through them you can
have dirty reads. The only confusing part is that a rollback doesn't affect
records but you are not going to get a deadlock if the other user rolls back
so its no big deal in this scenario.

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