Path: news.easynews.com!easynews!uunet!dfw.uu.net!ash.uu.net!news.chatlink.com!not-for-mail
From: Pieter <phuiberts@ivwnet.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: column total in forms
Date: Sun, 07 Jul 2002 11:13:19 -0400
Organization: OWDS Inc.
Lines: 19
Message-ID: <3D285A8F.5020200@ivwnet.com>
References: <3D279D7F.90504@ivw.com> <2ttfius3qs5apc7ropn7qvtq24csnsgbfb@4ax.com>
NNTP-Posting-Host: 1cust182.tnt1.frederick.md.da.uu.net
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.chatlink.com 1026054800 11948 67.201.141.182 (7 Jul 2002 15:13:20 GMT)
X-Complaints-To: abuse@chatlink.com
NNTP-Posting-Date: Sun, 7 Jul 2002 15:13:20 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3
X-Accept-Language: en,nl,pdf
Xref: easynews comp.databases.oracle.tools:52257
X-Received-Date: Sun, 07 Jul 2002 08:10:35 MST (news.easynews.com)

thanks for the advise, but my point is that I like to first check out 
that the time is distributed to 100% and than commit to make sure I save 
  good date, or do I make a mistake in my thinking.

Thanks

Holger Linge wrote:

>>Is it possible to do something like total := row1 + row2 + row3, where 
>>the cursor loops from the records?
>>
> 
> I would try it with the ON-COMMIT-TRIGGER. Check the sum
> directly in the database. So you don't have to deal with
> jumping around in the block.
> 
> 
>