I've seen this behaviour before . I tend to always call wonders deleteallobectsfromrelatiomship ( or something like that, sorry I don't have code or reference docs to hand!) before deleting the main object which gets around the issue
Simon On Monday, October 26, 2009, Freddie Tilley <[email protected]> wrote: > I have a Tree object linking to itself via a parent id and when I set > the child relationship to cascade. > > But when I delete the parent object (with children), I get the following > error: > > com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression > failed: : Next exception:SQL State:23000 -- error code: 547 -- msg: > The DELETE statement conflicted with the SAME TABLE REFERENCE > constraint "Tree_parent_FK". The conflict occurred in database > "TreeDatabase", table "dbo.Tree", column 'parentID'. > > It looks like the cascade isn't working. > > Is there a workaround/fix for this problem? > > I'm using WebObjects 5.4.3 > SQLServer 2005 > And Chuck Hills MicrosoftPlugIn > > -- > Freddie Tilley > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/simon%40potwells.co.uk > > This email sent to [email protected] > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
