Home » Developer & Programmer » Forms » Sum of Summrized Item (Oracle 10g, Forms6i)
Sum of Summrized Item [message #403393] Fri, 15 May 2009 05:45 Go to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
Dear All

Could I get sum of any summarized item and will they reside in a same block or different?

Basically, I have three different blocks in a form
1- master
2- detail
3- sub-detail

detail and sub-detail blocks contains two separate summarized item and I want to check these two items at the time of record saving, if these items are equal then save otherwise raise error message.

Please give me your great suggestions.
Re: Sum of Summrized Item [message #403438 is a reply to message #403393] Fri, 15 May 2009 11:09 Go to previous messageGo to next message
klat
Messages: 87
Registered: May 2009
Location: Mumbai
Member

Quote:

detail and sub-detail blocks contains two separate summarized item and I want to check these two items at the time of record saving, if these items are equal then save otherwise raise error message.



if :sub_detail.summarized_item=detail.summarized_item then

<Your code>


Re: Sum of Summrized Item [message #403656 is a reply to message #403438] Sun, 17 May 2009 23:07 Go to previous messageGo to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
Thanks for the reply but as I mentioned in my first post about three blocks
1) Master
2) Detail
3) Sub-Detail

so your given suggestion isn't enough to check values because DETAIL block summrized item contains all records total but the SUB-DETAIL block contains only current record total.

I want to stop user or I don't want to save records, if these totals are not equal.

[Updated on: Mon, 18 May 2009 00:52]

Report message to a moderator

Re: Sum of Summrized Item [message #404502 is a reply to message #403656] Fri, 22 May 2009 00:45 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I suggest that you change your design so that the sum on the sub-detail item populates the detail item automatically. That way the user does not have to enter the database twice.

David
Previous Topic: To Get Processor serial no. its urgent !!!!!!!!!!!!!!1
Next Topic: how to handle ocx items
Goto Forum:
  


Current Time: Sat Dec 03 12:11:15 CST 2016

Total time taken to generate the page: 0.08282 seconds