Avoid recursive trigger

Article View: borland.public.interbase.sql

Article #11196

Back to borland.public.interbase.sql Previous Next

#11196

From: Emi Garcia
Date: Tue, 10 Dec 2002 13:00

8 lines
1277 bytes

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.
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 .
Someone can help me?

Technical Details

Message-ID: <3df5e619@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,744a7a3b4fe7b4d5,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-10 05:29:29 PST
From: "Emi Garcia" <noundo@telefonica.net>
Newsgroups: borland.public.interbase.sql
Subject: Avoid recursive trigger
Date: Tue, 10 Dec 2002 14:00:41 +0100
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 80.34.168.185
Message-ID: <3df5e619@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039525401 80.34.168.185 (10 Dec 2002 05:03:21 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail