Re: Trigger Failing

From: damorgan <damorgan_at_exesolutions.com>
Date: Thu, 28 Mar 2002 16:49:35 GMT
Message-ID: <3CA349A2.F3CB15DA@exesolutions.com>

Marc's answer is correct ... but I think he is interpreting your question as a row lock and you specifically say "lock on the table". What is actually locked here? And if it is the entire table ... why? And for how long?

Daniel Morgan

Harry wrote:

> Hi all,
>
> We have a trigger that updates table B when table A is modified.
>
> If it can't update table B immediatly (because of a lock on the
> table for example) what will it do? Will it fail? Will it wait?
>
> Is there anyway to control this behavior?
>
> Thanking you..
> Harry
Received on Thu Mar 28 2002 - 10:49:35 CST