OraFAQ Forum: Forms » Trigger on a Summarized Column

Home » Developer & Programmer » Forms » Trigger on a Summarized Column (Oracle Forms 6i)

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

Trigger on a Summarized Column [message #606993]

Fri, 31 January 2014 15:08

praveenramaswamy
Messages: 34
Registered: December 2013

Member

Dear All

Thanks for taking time to assist me in your spare time. I use oracle Forms 6i.

I have a Summarized Item (Ex: Total Amount). The amount is displayed by totalling others amounts. Now i have to compare this Total Amount with say a value(ex:10000) and if the Total Amount is Greater than 10000, do some transactions.

Can you please tell me what kind of trigger i can write for this

Report message to a moderator

Re: Trigger on a Summarized Column [message #607006 is a reply to message #606993]

Sat, 01 February 2014 03:32

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

my question to you you wanted to check Gtot from table OR GTot is Non-database item thn its simple

WHEN-VALIDATE-ITEM---trigger

BEGIN
   if :A.GTOT > 1000 then
      message('!!! GTO IS GRATER THAN 1000');
      message('!!! GTO IS GRATER THAN 1000');
 
      raise form_trigger_failure;

end if;
end;

or if you want to check from table thn let me know little will be in code.Example .FMB attached

Regard
Mughal

Attachment: summ_trg.fmb
(Size: 44.00KB, Downloaded 5091 times)

Report message to a moderator

Re: Trigger on a Summarized Column [message #607007 is a reply to message #607006]

Sat, 01 February 2014 03:35

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

screen shot for those who are not installed Dev. in their pc's

Attachment: screen_shot.PNG
(Size: 51.75KB, Downloaded 4660 times)

Report message to a moderator

Previous Topic:	window not closed
Next Topic:	Mandatory Values/LOV Prohibited values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 22:42:10 CDT 2024