Hi,

Maybe in the After update trigger, you're doing a update again to
that same table, so the before update trigger will be called again...

HTH
Nico Callewaert
Freelance developer


-----Oorspronkelijk bericht-----
Van: Istvan Mesaros [mailto:mistvan@...]
Verzonden: woensdag 13 juni 2001 10:35
Aan: IBObjects@yahoogroups.com
Onderwerp: [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/