Hey List,

I am importing a bunch of relational data into a project and when I try to save 
changes I get an error something like this:

Error when attempting to save data: EvaluateExpression failed: : Next 
exception:SQL State:23000 -- error code: 1452 -- msg: Cannot add or update a 
child row: a foreign key constraint fails (`valueA`.`valueB`, CONSTRAINT 
`TableA_tableBID_id_FK` FOREIGN KEY (`tableBID`) REFERENCES `tableB` (`id`))

I know it is because they are not written to the database in the order created. 
I have dealt with this in the past by doing incremental saving and other 
awkward things, but in this case that would be a total pain.

Any suggestions for the best way to deal with this?

Thank you,

Steve Peery 
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to