🚀 go-pugleaf

Hi,

> I need to made a trigger that updates a set of records when a record is
> updated.
> The problem is that the trigger only must run when the first update
> statement is executed.

So you are updating the table that the trigger is on? Pff, the only way I
can think of is to update some dummy column to "UPDATE_BY_TRIGGER"
and in your trigger code do something like:

if (new.mydummycolumn <> 'UPDATE_BY_TRIGGER')
then begin
      // do my stuff
    end

> The update statements inside the body trigger must not fire the trigger.
> I try to alter trigger trigger to inactive in the first line of the tigger
> code but I get an error from interbase .

Of course - it's DDL, which isn't allowed in procedures or triggers.



--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."