Hi Steve, You can make a delegate to handle the ordering of database operations.
Chuck Hill made one that might just work for you but if you need something additionally custom you’ll have to take over. https://lists.apple.com/archives/webobjects-dev/2007/Jun/msg00751.html <https://lists.apple.com/archives/webobjects-dev/2007/Jun/msg00751.html> AARON ROSENZWEIG / Chat 'n Bike <http://www.chatnbike.com/> e: aa...@chatnbike.com <mailto:aa...@chatnbike.com> t: (301) 956-2319 > On May 25, 2017, at 10:54 AM, Steve Peery <spe...@me.com> wrote: > > 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/aaron%40chatnbike.com > > This email sent to aa...@chatnbike.com
_______________________________________________ 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
