Path: news.easynews.com!easynews!uunet!dfw.uu.net!ash.uu.net!news.chatlink.com!not-for-mail
From: "Pieter J.D. Huiberts" <phuiberts-REMOVE@ivw.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools
Subject: column total in forms
Date: Sat, 06 Jul 2002 21:46:39 -0400
Organization: OWDS Inc.
Lines: 21
Message-ID: <3D279D7F.90504@ivw.com>
NNTP-Posting-Host: 1cust227.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 1026006374 24863 67.201.141.227 (7 Jul 2002 01:46:14 GMT)
X-Complaints-To: abuse@chatlink.com
NNTP-Posting-Date: Sun, 7 Jul 2002 01:46:14 +0000 (UTC)
To: oracle-dev-l@OpenITx.com
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529
X-Accept-Language: en-us, en
Xref: easynews comp.databases.oracle.misc:83898 comp.databases.oracle.tools:52246
X-Received-Date: Sat, 06 Jul 2002 18:49:48 MST (news.easynews.com)

Hello,
I am developing a time distribution form in forms (dev/2000). The user 
gets pressented its projects in rows, and can than assign how much of 
his time (%) he spend on a project each month. Before committing this 
info to the db, I would like to validate that the time totals to 100%. 
How can I total these text_items before committing them into the db?

Is it possible to do something like total := row1 + row2 + row3, where 
the cursor loops from the records?

example:
The user sees this form and only fills out % of his time spend.
Projects        Time (%)
Project 1        33
Project 2        33
Project 3        33
          Total    99%

Thanks a bunch,
Piet