Click here to Skip to main content
15,918,258 members
Home / Discussions / Database
   

Database

 
GeneralRe: xBase question Pin
David Crow8-Feb-12 3:09
David Crow8-Feb-12 3:09 
GeneralRe: xBase question Pin
Peter_in_27808-Feb-12 10:05
professionalPeter_in_27808-Feb-12 10:05 
AnswerRe: xBase question Pin
Mycroft Holmes7-Feb-12 13:24
professionalMycroft Holmes7-Feb-12 13:24 
QuestionPlease help :MERGE Statement conflict with the foreign key constraint Pin
anushh6-Feb-12 23:46
anushh6-Feb-12 23:46 
AnswerRe: Please help :MERGE Statement conflict with the foreign key constraint Pin
Wes Aday7-Feb-12 3:26
professionalWes Aday7-Feb-12 3:26 
QuestionDataBase - protection / encryption Pin
Alberto Neves6-Feb-12 4:39
Alberto Neves6-Feb-12 4:39 
AnswerRe: DataBase - protection / encryption Pin
Eddy Vluggen6-Feb-12 5:26
professionalEddy Vluggen6-Feb-12 5:26 
QuestionPlease help with an UPDATE statement conflicted with the FOREIGN KEY constraint problem Pin
AlexanderBlade5-Feb-12 14:39
AlexanderBlade5-Feb-12 14:39 
Hi can someone help me to solve a foreign key constraint problem? I’m using using Web Developer 2010 Express with mvc3. When my view loads I can create an object by clicking on the Create button but on the edit page, I click on save button and get an error message: That says my UPDATE statement conflicted with the FOREIGN KEY constraint giving the tables relationship and the column.

Here’s what I’ve tried so far: I researched and found that this error is a bug in SQL Server 7.0. but I'm using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1

I found another tip that suggested that the id field in the main table is perhaps being called before the id fields of the associated table(s) was created. I tried changing the order by seeding all the other tables with data before my main table in my DBInitializer class. I also changed the order in my DBContext class… same error. Finally I decided to change the relationship directly in the database. I removed the relationship and created a new one (had to add fields in the main table to match the number of columns in the associated table). Nothing worked. I then removed the SetInitializer line from my Global.asax and created all tables from scratch directly in the database and as I created them, I found that I had to add data to the associated tables before adding stuff to my main table which seems to support an earlier suggestion but I still got the error message.

I then changed my SetInitializer back to seed the tables still got the same error. I have no problems when I click the “Create” button, only “Save” on the Edit page.

Any help would be greatly appreciated.
AnswerRe: Please help with an UPDATE statement conflicted with the FOREIGN KEY constraint problem Pin
Shameel5-Feb-12 19:42
professionalShameel5-Feb-12 19:42 
QuestionSSMS question Pin
SQL Ed4-Feb-12 6:24
SQL Ed4-Feb-12 6:24 
AnswerRe: SSMS question Pin
Eddy Vluggen4-Feb-12 22:52
professionalEddy Vluggen4-Feb-12 22:52 
QuestionNeed help for Customize the except query Pin
ptr_Electron3-Feb-12 1:30
ptr_Electron3-Feb-12 1:30 
AnswerRe: Need help for Customize the except query Pin
jschell3-Feb-12 11:02
jschell3-Feb-12 11:02 
AnswerRe: Need help for Customize the except query Pin
Mycroft Holmes3-Feb-12 12:00
professionalMycroft Holmes3-Feb-12 12:00 
GeneralRe: Need help for Customize the except query Pin
ptr_Electron3-Feb-12 22:53
ptr_Electron3-Feb-12 22:53 
QuestionOracle - odd behavior with nested select/join Pin
Paladin20002-Feb-12 9:19
Paladin20002-Feb-12 9:19 
AnswerRe: Oracle - odd behavior with nested select/join Pin
Mycroft Holmes2-Feb-12 13:16
professionalMycroft Holmes2-Feb-12 13:16 
GeneralRe: Oracle - odd behavior with nested select/join Pin
Jörgen Andersson2-Feb-12 21:32
professionalJörgen Andersson2-Feb-12 21:32 
AnswerRe: Oracle - odd behavior with nested select/join Pin
Jörgen Andersson2-Feb-12 21:31
professionalJörgen Andersson2-Feb-12 21:31 
GeneralRe: Oracle - odd behavior with nested select/join Pin
Paladin20003-Feb-12 4:14
Paladin20003-Feb-12 4:14 
QuestionInsert Statment Pin
Seema Bawa2-Feb-12 9:05
Seema Bawa2-Feb-12 9:05 
AnswerRe: Insert Statment PinPopular
jschell2-Feb-12 9:13
jschell2-Feb-12 9:13 
QuestionRe: Insert Statment Pin
Chris Meech2-Feb-12 15:30
Chris Meech2-Feb-12 15:30 
AnswerRe: Insert Statment Pin
Corporal Agarn3-Feb-12 1:24
professionalCorporal Agarn3-Feb-12 1:24 
AnswerRe: Insert Statment Pin
Dnyanesh Wahiley8-Feb-12 1:25
Dnyanesh Wahiley8-Feb-12 1:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.