Delete record 'friendly' message

Is there any way to display a 'friendly' message about restricting deletion of a record in a parent table if there are dependent records in the child table? Using InnoDB tables.
Would I have to code this myself or is there something in Data Bridge I can use?
I would need to use it with the DataAssist 'Multiple record delete' SB

I don't want people to be presented with a mysql message >>
"Cannot delete or update a parent row: a foreign key constraint fails ... "

Rather: "This record has dependent records. Can't be deleted" then redirect.

Also I need a CANCEL button, so I put the following code just above the 'WA DataAssist Multiple Deletes' code block:

*************************************
<?php if (array_key_exists('Cancel', $_POST)) {
header('Location: redirect.php');
exit;
}
?>

*************************************

but this does not work. I've used it countless times using the Dreamweaver 'Delete record' SB.

Cheers
Dave

you would need to code this your self.

you would need to capture the ID's of the records being deleted, look them up in the dependent table and display the message if they exist.


Your code for the cancel will only work if the name of the button is "Cancel" if it is not working, it means you are using a different name for the cancel button.

Thanks Jason. The id of the Cancel button is 'cancel'. Should have put:

if (array_key_exists('cancel', $_POST))

Now it works - don't know why I didn't pick that up before.

I've sorted out the deletion problem - I used a recordset with a LEFT JOIN & NULL to only display the records that are not being used (orphaned)