Re: cumulative balance field

Article View: borland.public.interbase.sql

Article #304

Back to borland.public.interbase.sql Previous Next

#304

From: Isaac
Date: Sun, 18 May 2008 19:35

17 lines
1739 bytes

Bill Todd [TeamB] wrote:
> Isaac wrote:
> 
>> What you mean by a stored procedure in a view ?? please explain more
> 
> Write a selectable stored procedure that returns the data with the
> running balance included. Assume the procedure is named RunningBalance.
> Next create a view that uses the following SELECT.
> 
> SELECT FLD1, FLD2, FLD3, ETC FROM RUNNINGBALANCE
> 
> The section on views in the Data Definition Guide explains how you can
> add triggers to a view to allow you to update a view that would not
> normally be updateable. This would allow users of the application to
> edit the result set returned by the stored procedure.
> 
Many thanks appreciate your help

Technical Details

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

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<4822380f@newsgroups.borland.com> <48235cbc@newsgroups.borland.com> <4823719d$1@newsgroups.borland.com> <4824d84c@newsgroups.borland.com> <4824df04$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
Date: Sun, 18 May 2008 22:35:47 +0300
From: Isaac <no@no.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: cumulative balance field
References: <4822380f@newsgroups.borland.com> <48235cbc@newsgroups.borland.com> <4823719d$1@newsgroups.borland.com> <4824d84c@newsgroups.borland.com> <4824df04$1@newsgroups.borland.com>
In-Reply-To: <4824df04$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 41.234.198.204
Message-ID: <48308527$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1211139367 41.234.198.204 (18 May 2008 12:36:07 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message