Foreign Key constraint check

Foreign Key constraint check

El Forum
Unregistered

05-24-2009, 11:36 AM

[eluser]Jagar[/eluser]
Only InnoDb engine supports foreign keys, and that's why I changed it from MyIsam to innodb.

Everything is working fine, just want to know how to detect and display the error with foreign key on delete, rather than display the CI error like follow:

Code:
A Database Error Occurred

Error Number: 1451

Cannot delete or update a parent row: a foreign key constraint fails

Thanks for trying appreciate!

Messages In This Thread

Foreign Key constraint check - by El Forum - 05-23-2009, 09:14 PM

Foreign Key constraint check - by El Forum - 05-24-2009, 12:14 AM

Foreign Key constraint check - by El Forum - 05-24-2009, 11:14 AM

Foreign Key constraint check - by El Forum - 05-24-2009, 11:19 AM

Foreign Key constraint check - by El Forum - 05-24-2009, 11:24 AM

Foreign Key constraint check - by El Forum - 05-24-2009, 11:31 AM

Foreign Key constraint check - by El Forum - 05-24-2009, 11:36 AM

Foreign Key constraint check - by El Forum - 05-25-2009, 09:41 AM

Foreign Key constraint check - by El Forum - 03-10-2010, 12:11 PM

Foreign Key constraint check - by El Forum - 03-10-2010, 12:14 PM

Foreign Key constraint check - by El Forum - 03-10-2010, 12:28 PM

Foreign Key constraint check - by El Forum - 03-10-2010, 01:43 PM

Foreign Key constraint check - by El Forum - 04-05-2011, 01:58 PM

Foreign Key constraint check - by El Forum - 04-05-2011, 11:34 PM

Foreign Key constraint check - by El Forum - 04-06-2011, 01:26 PM