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..