Server: Msg 547, Level 16, State 1, Procedure error_demo_sp, Line 2 UPDATE statement conflicted with COLUMN FOREIGN KEY constraint 'fk7_acc_cur'. The conflict occurred in database 'bos_sommar', table 'currencies', column 'curcode'. The statement has been terminated.
what kind of this error is please tell me.
Error in Query Execution
hi friends,
NarayanPosted Nov 21, 2011, 9:20 PM
When you are updating record you are trying update with some value in curcode column which is not a valid foreign key ( it should a value from the column which is referred )