4 Replies Latest reply: Sep 14, 2013 2:36 AM by Dev. Musbah RSS

    Post query trigger problem in master detail oracle forms

    979801

      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.