Re: cumulative balance field

Article View: borland.public.interbase.sql

Article #381

Back to borland.public.interbase.sql Previous Next

#381

From: Bill Todd [TeamB]
Date: Thu, 08 May 2008 17:39

17 lines
1787 bytes

Isaac wrote:

> In fact debit and credit fields can be changed by user at any time, I
> think I will need another trigger ? plz post any short examples of
> triggers I did not use them before

In that case storing the running balance may be expensive since a
change to the debit or credit amount in any row will change the balance
for every subsequent row. Triggers and stored procedures are explained
in the IB Data Definition Guide. It is impossible to explain the entire
subject of triggers in a newsgroup message. After you read the Data
Definition Guide chapters on stored procedures and triggers you can
post any specific questions you have and someone will try to answer
them.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <48233ade@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.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!newsgroups.borland.com!not-for-mail

References: <4822380f@newsgroups.borland.com> <482246d0$1@newsgroups.borland.com> <48231e5b$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,7fe0f2b0b1ac1758
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: cumulative balance field
Newsgroups: borland.public.interbase.sql
References: <4822380f@newsgroups.borland.com> <482246d0$1@newsgroups.borland.com> <48231e5b$1@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: 65.118.176.23
Message-ID: <48233ade@newsgroups.borland.com>
Date: 8 May 2008 10:39:42 -0700
X-Trace: newsgroups.borland.com 1210268382 65.118.176.23 (8 May 2008 10:39:42 -0700)
Lines: 17
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news2.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!newsgroups.borland.com!not-for-mail

Reply to Parent Message