Subject Re: Re: [IBO] AfterUpdate and BeforeUpdate triggers executed twice
Author Istvan Mesaros
I must use PessimisticLocking, so I can't drop this option. How can I tell
in a trigger if it's a dummy or a real update?


Istvan


----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, June 13, 2001 02:43 PM
Subject: Re: [IBO] AfterUpdate and BeforeUpdate triggers executed twice


> Either stop using PessimisticLocking or make your triggers smart enough to
> tell the difference between the dummy update and a real update.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Istvan Mesaros" <mistvan@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Wednesday, June 13, 2001 1:34 AM
> Subject: [IBO] AfterUpdate and BeforeUpdate triggers executed twice
>
>
> > If a TIB_QUERY has PessimisticLocking set to TRUE and the table from
which
> > the query takes its values has a BeforeUpdate or AfterUpdate trigger,
> these
> > triggers are executed twice if the query is edited. Can someone help me?
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>