?
Solved

SQL Delete error in Dotnetnuke

Posted on 2010-08-16
2
Medium Priority
?
315 Views
Last Modified: 2013-11-19
critical error has occurred.
The DELETE statement conflicted with the REFERENCE constraint "FK_BK_StaffDirectory_PersonTitle_BK_StaffDirectory_Person". The conflict occurred in database "USR_BrooksKushman-DNN", table "dbo.BK_StaffDirectory_PersonTitle", column 'PersonId'. The statement has been terminated.
0
Comment
Question by:benharel
2 Comments
 
LVL 7

Expert Comment

by:rmm2001
ID: 33448666
Looks like what's happening is that you're trying to delete a row that has a key on it that other tables reference. My guess is that it's your StaffDirectory table. Delete the data out of there for your desired dataset first and then out of the BK_Staff_Directory_Personal_Title table
0
 
LVL 6

Accepted Solution

by:
rbgCODE earned 2000 total points
ID: 33458770
You need to make sure that your deleted are running cascading so that if there is a parent child relationship that all child entries are deleted before the parent.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
The viewer will learn how to dynamically set the form action using jQuery.
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question