This discussion is archived
4 Replies Latest reply: Sep 14, 2013 12:36 AM by Dev. Musbah RSS

Post query trigger problem in master detail oracle forms

979801 Newbie
Currently Being Moderated

Hello experts,

                    I am new in oracle forms n using Fission middleware 10g with oracle forms 11g at windows 7 platform.

I have made a master detail form using a tab canvas.There is a database column STUDENTID and it is in my student tab with a TBL_STUDENTENTRY data block.Now I Have an another tab named previous_education with TBL_STUDENT_PREVIOU_EDU datablock here there is also a database column STUDENTID and corresponding field in my  previous_education TAB under TBL_STUDENT_PREVIOU_EDU  datablock.Now i want to add a display item to show  student name corresponding to STUDENTID.For this I have tried to make a select query in TBL_STUDENT_PREVIOU_EDU data block POPST_QUERY TRIGGER.

 

begin
select STUDENTNAME into :TBL_STUDENT_PREVIOU_EDU.STD_NM   from TBL_STUDENTENTRY where STUDENTID=:TBL_STUDENTENTRY.STUDENTID;
end;

 

But, This trigger is not fired at runtime,Please suggest me what is going wrong and give me the solution.

Thank You

AADITYA.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points