Primary Key Constraint Error

[Anne]

Hello,

I am getting the following message when I am trying to insert into my table. Request is the primary keys and the Bus_Req_Id and Test_Case_Id are both foreign keys. The data that is being inserted into these fields are not unique.

This is the exact error message:

Violation of PRIMARY KEY constraint 'PK_REQUEST_BUS_REQ_TST'. Cannot insert duplicate key in object 'REQUEST_BUS_REQ_TST'.
The statement has been terminated.

I am trying to insert 700 - 900 rows based on certain criteria. If I delete the keys the inserts will work.

Any help would be most greatful.
Thank you in advance

Anne

[Ray Miao]

Pkey requires unique value.


------------
Anne at 10/30/01 12:43:54 PM


Hello,

I am getting the following message when I am trying to insert into my table. Request is the primary keys and the Bus_Req_Id and Test_Case_Id are both foreign keys. The data that is being inserted into these fields are not unique.

This is the exact error message:

Violation of PRIMARY KEY constraint 'PK_REQUEST_BUS_REQ_TST'. Cannot insert duplicate key in object 'REQUEST_BUS_REQ_TST'.
The statement has been terminated.

I am trying to insert 700 - 900 rows based on certain criteria. If I delete the keys the inserts will work.

Any help would be most greatful.
Thank you in advance

Anne