Post reply

Violation Constraints

  • July 22, 2006 at 12:28 pm

    #60940

    Server: Msg 2627, Level 14, State 1, Procedure SP_InsertNewInvoice, Line 42

    Violation of PRIMARY KEY constraint 'PK_InvoicePayment'. Cannot insert duplicate key in object 'InvoicePayment'.

    The statement has been terminated.

    Server: Msg 2627, Level 14, State 1, Procedure SP_InsertNewInvoice, Line 45

    Violation of PRIMARY KEY constraint 'PK_Payment'. Cannot insert duplicate key in object 'Payment'.

    The statement has been terminated.

    Server: Msg 2627, Level 14, State 1, Procedure SP_InsertNewInvoice, Line 48

    Violation of PRIMARY KEY constraint 'PK_PaymentTypes'. Cannot insert duplicate key in object 'PaymentTypes'.

    The statement has been terminated.

    Server: Msg 2627, Level 14, State 1, Procedure SP_InsertNewInvoice, Line 58

    Violation of PRIMARY KEY constraint 'PK_CreditCardPayment'. Cannot insert duplicate key in object 'CreditCardPayment'.

    The statement has been terminated.

  • July 24, 2006 at 4:27 pm

    #651207

    The error description says that you are inserting duplicate values. Check the values being inserted in the tables.

  • July 26, 2006 at 9:33 pm

    #651787

    if we add the value PaymentId  for example(1,2,3) then all paymentId related fields we add the 1,2,3 value but when we add these value then they gave me a error?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply