Carlos,

you can avoid that by checking and encapsulating trigger expressions with
sth. like that:

if (old.value<>new.value) then

Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
www.ibp-consult.com

----- Original Message -----
From: "Carlos H. Cantu" <ibo@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, May 15, 2001 1:30 PM
Subject: [IBO] Pessimisc locking and triggers


> Hi !
>
> Someone asked me a question and I'm wondering if someone has the solution
:
>
> He uses pessimistic locking with IBO. The problem is that he has triggers
> being triggered twice : 1st time when IBO make the null update on the
> record to "lock" it and 2nd time when the record is really edited by the
> user. Is there a way to skip the 1st run ?
>
> []s
>
> Carlos
> WarmBoot Informatica - http://www.warmboot.com.br
> Interbase-BR - http://www.interbase-br.com
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>