Hi Sir,
Good Morning, I want to delete data from 3 forms on a single click Eg: in form 1
I have created a record that record I'd is related to form 2 and form 3
If I delete the record A11, then from all the 3 forms A11 record should be deleted.
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
To delete the related/child records from all the child tables, follow these steps:
In form-1, create a process to delete the records from child tables. The following is an example of the PL/SQL process code to delete the child records:
Change p1_id with your form-1 id column.
Make sure that this process should be placed before the close dialog process if you are using dialog forms.
You can also do this using the database trigger.
Create an after delete trigger on the form-1 table and delete the records from the child tables:
Swarup
Thanks sir let me check and get back to u
Swarup
Hi sir,
Good Morning,will this trigger work for my scenario
CREATE OR REPLACE TRIGGER after_delete
AFTER DELETE
ON V_REGISTER
FOR EACH ROW
BEGIN
Delete from V_CONTACT where VOLUNTEER_ID = :OLD.VOLUNTEER_ID;
Delete from V_HEALTH where VOLUNTEER_ID = :OLD.VOLUNTEER_ID;
END;
Vinish Kapoor
Yes, 100% it will work.
Swarup
Thanx sir,it works fine thnx for support