Home » Developer & Programmer » Forms » how to create calculated item in Forms Version 4.5.8.1.2  () 1 Vote
how to create calculated item in Forms Version 4.5.8.1.2 [message #202262] Wed, 08 November 2006 21:51 Go to next message
qewani
Messages: 51
Registered: December 2005
Location: uaq
Member

how to create calculated item in Forms Version 4.5.8.1.2

please help!
Re: how to create calculated item in Forms Version 4.5.8.1.2 [message #202266 is a reply to message #202262] Wed, 08 November 2006 22:04 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Manually.

David
Re: how to create calculated item in Forms Version 4.5.8.1.2 [message #202271 is a reply to message #202266] Wed, 08 November 2006 22:14 Go to previous messageGo to next message
qewani
Messages: 51
Registered: December 2005
Location: uaq
Member

ok if i had a field named price and another field called total price
i want the total price field to give me a summary of the price field , so which trigger do i use? and how the code to calculate summary would be?
Re: how to create calculated item in Forms Version 4.5.8.1.2 [message #202279 is a reply to message #202271] Wed, 08 November 2006 22:42 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I assume that you have a Master-Detail relationship of some kind.

'Price' is in your detail block, 'Total_Price' is in a non-database block or as a non-database field in the master block.

You could loop through the detail records after you have retrieved them all, but if you had millions that would be painful. You could populate 'Total_Price' in the 'Post_Query' trigger of the detail block but then you would be doing it for every record retrieved, and that is a waste of resources. I prefer to do it in the 'Post-Query' of the master block.

David

Previous Topic: Timed Out and Connection Again
Next Topic: Diff bet Rownum And Rowid (ORA-01445 using ROWID in Forms)
Goto Forum:
  


Current Time: Sun Dec 04 10:22:59 CST 2016

Total time taken to generate the page: 0.09131 seconds