Home » Developer & Programmer » Forms » Trigger on a Summarized Column (Oracle Forms 6i)
Trigger on a Summarized Column [message #606993] Fri, 31 January 2014 15:08 Go to next message
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
Re: Trigger on a Summarized Column [message #607006 is a reply to message #606993] Sat, 01 February 2014 03:32 Go to previous messageGo to next message
mughals_king
Messages: 390
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 312 times)
Re: Trigger on a Summarized Column [message #607007 is a reply to message #607006] Sat, 01 February 2014 03:35 Go to previous message
mughals_king
Messages: 390
Registered: January 2012
Location: pakistan
Senior Member
screen shot for those who are not installed Dev. in their pc's
Previous Topic: window not closed
Next Topic: Mandatory Values/LOV Prohibited values
Goto Forum:
  


Current Time: Fri Dec 19 19:38:33 CST 2014

Total time taken to generate the page: 0.28826 seconds