Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Forms4.5 How to Calculate subtotal while making Data entry.

Forms4.5 How to Calculate subtotal while making Data entry.

From: <nagparag_at_hotmail.com>
Date: Sat, 05 Sep 1998 09:53:54 GMT
Message-ID: <6sr1nh$n3b$1@nnrp1.dejanews.com>


Your Kind attention please.
I am having a block defination with multiple record display( 5 Records ). Say for Example EMP table
Columns Such As Ename and Salary.
While adding records to emp table through Forms45 I want the subtotal of what all Salary is entered.

John 3000
Scott 4000

 Total 7000

I have tried writing a key-nxtfld trigger on Item Salary passing a value to global Variable,it calculates the total but when I modify the entered value it again adds the modified value rather than the difference.

How do i go about it.
Which trigger I should write and How ?

Thanks in Advance.

Paggy.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Sep 05 1998 - 04:53:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US