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/archive%40mail-archive.com This email sent to [email protected]
