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?