RE: Violation of primary key error - how to troubleshoot

: Violation of primary key error - how to troubleshoot Thanks Ian and Will. I should have explained better, or at least shown the SQL. I'm not trying to insert the ID field, just the other fields. Will, no I cannot manually enter the data. I'm going to pass it off as corrupt data for no

Re: Violation of primary key error - how to troubleshoot

Thanks Ian and Will. I should have explained better, or at least shown the SQL. I'm not trying to insert the ID field, just the other fields. Will, no I cannot manually enter the data. I'm going to pass it off as corrupt data for now (this is on a testing db) and see if it resolves itself after re

Re: Violation of primary key error - how to troubleshoot

>I need help in how to troubleshoot this issue. I get this error when >trying to do an insert. > Can you manually enter the data into the table? ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable R

Re: Violation of primary key error - how to troubleshoot

You have code in your SQL statement that is trying to set a value to this key field? That would not be allowed. The auto increment start value may have been reset with data still in the table, I don't know if this is possible. ~~

Violation of primary key error - how to troubleshoot

I need help in how to troubleshoot this issue. I get this error when trying to do an insert. Violation of PRIMARY KEY constraint 'pk_FieldName'. Cannot insert duplicate key in object 'SomeTable'. The field in question is the primary key and is an identity column set to auto-increment by 1. How ca