slycknick
-
4/22/2009 8:11:07 AM
API to delete nodes
I'm tring to use the API to delete a node and all its children using productTreeNode.DeleteAllCultures()
The problem I'm getting is that this produces a contraint error
Error [DataConnection.ExecuteQuery]: Query: DELETE FROM CMS_Document WHERE [DocumentID] = @ID: caused exception: The DELETE statement conflicted with the REFERENCE constraint "FK__CMS_Attac__Attac__09A971A2". The conflict occurred in database "WMEC", table "dbo.CMS_Attachment", column 'AttachmentDocumentID'. The statement has been terminated.
Is this the correct method to use or do I have to manually recurse through the tree and delete all children one by one.
Thanks Nick
|