1 2 Previous Next 17 Replies Latest reply: Apr 25, 2013 1:01 PM by user626836 Go to original post RSS
      • 15. Re: Unhandled Exception Forms 6i
        user626836
        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
          should I add that trigger in my block level?
          Yes
          • 17. Re: Unhandled Exception Forms 6i
            user626836
            Thanks a lot for your help Steve!!!
            1 2 Previous Next