OraFAQ Forum: Forms » who i make sum

Home » Developer & Programmer » Forms » who i make sum

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

who i make sum [message #199313]

Mon, 23 October 2006 07:04

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

Report message to a moderator

Re: who i make sum [message #199315 is a reply to message #199313]

Mon, 23 October 2006 07:50

Littlefoot
Messages: 21818
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;

Report message to a moderator

Re: who i make sum [message #199327 is a reply to message #199315]

Mon, 23 October 2006 09:59

farooq112
Messages: 90
Registered: September 2006
Location: cairo

Member

thanks for answer

my frind

the total items
tel me code

Report message to a moderator

Re: who i make sum [message #199337 is a reply to message #199327]

Mon, 23 October 2006 11:48

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

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.

Report message to a moderator

Re: who i make sum [message #199376 is a reply to message #199327]

Mon, 23 October 2006 18:44

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

About the sum of values, search this forum for 'Calculation' or 'Summary function'.

David

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 14:20:59 CDT 2024