Home » Developer & Programmer » Forms » How to get cummulative sum of a column (forms 6i, oracle 9i)
How to get cummulative sum of a column [message #322067] Thu, 22 May 2008 05:45 Go to next message
bernandas
Messages: 16
Registered: June 2007
Location: Chennai
Junior Member
Dear All,
i have a data block CUMM_SUM(no.of rows - 10). Which contains two columns and a display field(no.of row 1) .

1. ITEM_NAME - PRIMARY KEY
2. QTY - NUMBER

example date
-------------
item_name qty

i1 10
i2 5
i3 15

while entering first item i need to show 10 in the display item,
while entering second item i need to show 15 in the display item,
while entering third item i need to show 30 in the display item, etc...

thanks in advance
Re: How to get cummulative sum of a column [message #322227 is a reply to message #322067] Thu, 22 May 2008 18:25 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

do the computation in each item when-validate-item trigger.
Re: How to get cummulative sum of a column [message #322959 is a reply to message #322227] Mon, 26 May 2008 23:32 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
And what do you want displayed when the records are retrieved by a query?

David
Previous Topic: Outer join in ORacle forms 6i
Next Topic: Strange Error When Connecting Form 6i
Goto Forum:
  


Current Time: Sat Dec 03 18:00:10 CST 2016

Total time taken to generate the page: 0.21035 seconds