OraFAQ Forum: Forms » How to count in list block?

Home » Developer & Programmer » Forms » How to count in list block? (Oracle Form6i and SQL)

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

How to count in list block? [message #525351]

Sat, 01 October 2011 07:24

m3nhaq
Messages: 20
Registered: September 2011
Location: Pakistan

Junior Member

Helloo To All

I have a list block of two fields item_name, item_price. User can enter as many item`s as she/he wants. But, before saving the record system should calculate the total and give error if sum is grater then or less than 100

Thanks for help
Regards
Muteen

Report message to a moderator

Re: How to count in list block? [message #525352 is a reply to message #525351]

Sat, 01 October 2011 09:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: How to count in list block? [message #525553 is a reply to message #525351]

Mon, 03 October 2011 13:38

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

I am not really sure about your question, but look at the field properties under the CALCULATION seciotn. You will need to set the QUERY ALL RECORDS to YES for the block in order to use this.

Report message to a moderator

Previous Topic:	difference between oracle foms/reports 6i and 10g
Next Topic:	Executing .exe file on the local desktop from Oracle EBS Forms [merged 3]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 12:59:53 CDT 2024