Re: Foreign Key constraints and error 1451
Show us the SHOW CREATE TABLE for your two tables in question, and some sample data INSERTS to reproduce the problem.
If you are using the parent.sir_name as the foreign key, then you can't change it in the parent table without destroying the relationship to the child.
You need to be using a non-changeablefield as the foreign key.
Good luck,
Barry.
Subject
Written By
Posted
Re: Foreign Key constraints and error 1451
April 19, 2015 04:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.