It's a dummy update if nothing was actually updated.

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

----- Original Message -----
From: "Istvan Mesaros" <mistvan@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, June 13, 2001 5:12 AM
Subject: Re: Re: [IBO] AfterUpdate and BeforeUpdate triggers executed twice


> 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/
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>