Home/ Questions/Q 1645
In Process

vinish.ai Latest Questions

  • 1
  • 1
Asked: 2020-10-02T09:15:07+00:00

Deleting of data in Apex on single click

  • 1
  • 1

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.

oracle apexpl/sql
Share
Leave an answer

Leave an answer

Browse

5 Answers

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

    Delete from form2_table where id = :p1_id;
Delete from form3_table where id = :p1_id;

    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:

    Delete from form2_table where id = :old.id;
Delete from form3_table where id = :old.id;