Home » Developer & Programmer » Forms » who i make sum
who i make sum [message #199313] Mon, 23 October 2006 07:04 Go to next message
farooq112
Messages: 90
Registered: September 2006
Location: cairo
Member

i make three columns

price many total

i wont know triger and code

when i finshe write many total view auto

pls
Re: who i make sum [message #199315 is a reply to message #199313] Mon, 23 October 2006 07:50 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You didn't mention how would you like to calculate value of the 'total' item; I guess (and would be surprised if it is wrong, but who knows?) you want to multiply 'price * many'.

One solution might be this:

WHEN-VALIDATE-ITEM trigger on 'many' item:

:block_name.total := :block_name.price * :block_name.many;
Re: who i make sum [message #199327 is a reply to message #199315] Mon, 23 October 2006 09:59 Go to previous messageGo to next message
farooq112
Messages: 90
Registered: September 2006
Location: cairo
Member
thanks for answer

my frind

the total items
tel me code
Re: who i make sum [message #199337 is a reply to message #199327] Mon, 23 October 2006 11:48 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
http://www.orafaq.com/forum/fa/1600/0/ I'm sorry, but I don't understand ... I thought that was it. If not, well, either try to describe the problem once again so that I can figure it out, or wait for someone else to answer your question.
Re: who i make sum [message #199376 is a reply to message #199327] Mon, 23 October 2006 18:44 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
About the sum of values, search this forum for 'Calculation' or 'Summary function'.

David
Previous Topic: How to work with triggers
Next Topic: Information on Oracle10g
Goto Forum:
  


Current Time: Sat Dec 03 11:58:40 CST 2016

Total time taken to generate the page: 0.07905 seconds