Path: news.easynews.com!easynews!priapus.visi.com!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!dca.uu.net!news.chatlink.com!not-for-mail From: "Pieter J.D. Huiberts" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools Subject: Re: column total in forms Date: Sun, 07 Jul 2002 20:29:15 -0400 Organization: OWDS Inc. Lines: 41 Message-ID: <3D28DCDB.8060408@ivw.com> References: <3D279D7F.90504@ivw.com> NNTP-Posting-Host: 1cust112.tnt3.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 1026088120 15172 67.201.162.112 (8 Jul 2002 00:28:40 GMT) X-Complaints-To: abuse@chatlink.com NNTP-Posting-Date: Mon, 8 Jul 2002 00:28:40 +0000 (UTC) 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:83912 comp.databases.oracle.tools:52269 X-Received-Date: Sun, 07 Jul 2002 17:26:01 MST (news.easynews.com) Thanks guys! Your hints were just enough to solve my issue! Luis Cabral wrote: >Hi > >You didn't tell your forms version, but if you use 6i (or 5, I think) >you can use a computed control item. See the "calculation" group of >item properties. You can create a summary computed item that >automatically SUMs the percentages, an in the pre-commit trigger you >can check if it is = 100... > >hth > >"Pieter J.D. Huiberts" wrote in message news:<3D279D7F.90504@ivw.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 >> >>