4 Replies Latest reply: Mar 6, 2014 5:13 AM by zain.mr89 RSS

    How to delete multiple records by selecting checkbox

    zain.mr89

      Hi there I am a newbie in oracle forms builder. I want to delete multiple records at the same time when I click the button. I have an "emp_block" and a "control_block".

      emp_block information :-

           I have all the columns displayed in this block like empno,ename,sal,hiredate,deptno,comm.

           Other than these i've add new item which is of type "check box" and its name is "checkbox".

      control_block information :-

           I have a "push button" in this control block.

           I added trigger "when-button-pressed" and write this line of code :-

                EXECUTE_TRIGGER("ON-DELETE");

                COMMIT;

       

      "ON-DELETE" is a form level trigger. In that trigger i wrote this code :-

           BEGIN

                  DELETE FROM EMP WHERE EMPNO =:EMP_BLOCK.CHECKBOX;

           END;

       

      Problem :-

           Not a single selected record is deleted when i click the delete button.

           I want to select checkbox no matter how many, and when i press delete button it deleted all the records whose checkbox was selected.

       

      Please help me out..