Cascading Delete

[rpierce]

It would be great if AppGini had the ability to cascade delete all children records when a parent record is deleted. Just a thought.

[jsetzer]

Hmmm, should work.

Can you check the following settings:

1. Grant DELETE-permission on the subtables for the user's group who is deleting the master record
2. Check the correct setup of the lookups (as those connect a subtable's records to a master record)
3. Option [x] Delete records even if they have children records
4. Option [X] Allow mass delete on the master table
5. Just for clarification: Check the PHP function TABLENAME_delete() in TABLENAME_dml.php. All related subtables should have a separate block of code, starting with // child table: SUBTABLENAME. If your code does not delete related records of certain tables, check if those tables do have a separate code-block there. If not, I guess there is a problem with setup of that specific lookup.

If all of this does not enable cascading-delete, you can still delete in _before_delete()-hook. After deleting all child-records manually you should also cleanup orphanened membership_userrecords.

PS: Another idea is creating a trigger on database level, but, personally, I prefer not creating database triggers for better (=easier) portability/migration/updates.

[rpierce]

Hi Jan,

I have done the items you suggest and am able to delete the parent record but then I still have orphaned children records.