🚀 go-pugleaf

I've asked before try...
The update statement inside the trigger code do not fire the trigger....
Thanks.
"Martijn Tonies" <m.tonies@upscene_remove.com> escribi� en el mensaje
news:3df5ed1f$1@newsgroups.borland.com...
> 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."
>
>