INSERT statement conflicted with the FOREIGN KEY constraint
Posted
by SmartestVEGA
on Stack Overflow
See other posts from Stack Overflow
or by SmartestVEGA
Published on 2010-06-03T12:24:54Z
Indexed on
2010/06/03
12:34 UTC
Read the original article
Hit count: 243
I am getting the following error. Could you please help me in ?
Msg 547, Level 16, State 0, Line 1
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Sup_Item_Sup_Item_Cat". The conflict occurred in database "dev_bo", table "dbo.Sup_Item_Cat".
The statement has been terminated.
insert into sup_item (supplier_id,sup_item_id,name,sup_item_cat_id,status_code,last_modified_user_id,last_modified_timestamp,client_id) values(10162425,10,'jaiso','123123','a','12','2010-12-12','1062425')
the last coulum "client_id" i am getting the conflict. I tried to put the value which already exists in the dbo.Sup_Item_Cat to the column
corresponding to the sup_item.. but no joy :-(
© Stack Overflow or respective owner
