Re: trigger to get sum

Article View: borland.public.interbase.sql

Article #305

Back to borland.public.interbase.sql Previous Next

#305

From: Bill Todd [TeamB]
Date: Sun, 18 May 2008 20:34

19 lines
1763 bytes

Isaac wrote:

> Ok I wrote on trigger it fires after updating the table and it works
> good but I need the same calculations to be executed after insert and
> after delete is it ok to make the same trigger exactly 3 times ?

Yes.

> 
> - How this will interfere with other updates done inside the
> application it self ?

It does not interfere with anything. Any time an insert, update or
delete is performed the appropriate trigger will fire. It does not
matter what causes the data to change. The trigger will always execute.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <483092b8$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeeder.dynfx.net!weretis.net!news.isoc.lu!newsgroups.borland.com!not-for-mail

References:

<482f63f1$1@newsgroups.borland.com> <482f7efc@newsgroups.borland.com> <483029a4@newsgroups.borland.com> <48304da8$1@newsgroups.borland.com> <48308326@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,c564685cdb1305db
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: trigger to get sum
Newsgroups: borland.public.interbase.sql
References: <482f63f1$1@newsgroups.borland.com> <482f7efc@newsgroups.borland.com> <483029a4@newsgroups.borland.com> <48304da8$1@newsgroups.borland.com> <48308326@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 76.208.40.243
Message-ID: <483092b8$1@newsgroups.borland.com>
Date: 18 May 2008 13:34:00 -0700
X-Trace: newsgroups.borland.com 1211142840 76.208.40.243 (18 May 2008 13:34:00 -0700)
Lines: 19
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeeder.dynfx.net!weretis.net!news.isoc.lu!newsgroups.borland.com!not-for-mail

Reply to Parent Message