This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Apr 25, 2013 11:01 AM by user626836 Go to original post RSS
  • 15. Re: Unhandled Exception Forms 6i
    user626836 Newbie
    Currently Being Moderated
    Hi Steve and thanks for your reply,
    This option worked pretty well now after you made the changes and I added it in my WHEN-BUTTON-PRESSED, so if I follow your suggestion on putting the cursor in a post-query trigger, then should I add that trigger in my block level?
    BEGIN
      FIRST_RECORD;
      LOOP
        For C in
         ( Select CREDIT_VALUE, CREDIT_VALUE_Q2,
                     CREDIT_VALUE_Q3, CREDIT_VALUE_Q4
           FROM MATERIAS_ISS A, NOTAS_ISS B
           WHERE A.SCHOOL_ID   =:SCHOOL_ID
           AND   A.CLASS_ID    =:CLASS_ID
           AND   A.TEACHER_ID  =:TEACHER_ID
           AND   A.SCHOOL_YEAR =:SCHOOL_YEAR
           AND   A.SCHOOL_ID = B.SCHOOL_ID
           AND   A.CLASS_ID = B.CLASS_ID
           AND   A.TEACHER_ID = B.TEACHER_ID)
        Loop
          :CREDITO_UNO    := C.CREDIT_VALUE;
          :CREDITO_DOS    := C.CREDIT_VALUE_Q2;
          :CREDITO_TRES   := C.CREDIT_VALUE_Q3;
          :CREDITO_CUATRO := C.CREDIT_VALUE_Q4;
          -- always exit after populating the fields in the one row.
          Exit;
        End Loop;
        EXIT WHEN :SYSTEM.LAST_RECORD = 'TRUE'
        NEXT_RECORD;
      END LOOP;
    END;
  • 16. Re: Unhandled Exception Forms 6i
    user346369 Expert
    Currently Being Moderated
    should I add that trigger in my block level?
    Yes
  • 17. Re: Unhandled Exception Forms 6i
    user626836 Newbie
    Currently Being Moderated
    Thanks a lot for your help Steve!!!
1 2 Previous Next

Legend

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