LS,
I have searched this forum, but couldn't find an answer.
I have a table in MS SQL, which has a PK field, defined as an identity field, with autonumber.
When changing data, the update statement fails, because the PK cannot be updated (even though the data doesn't change).
I have tried to hide, make it uneditable etc.
Couldn't execute query. SQLState: 42000 Error Code: 8102 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot update identity column
How can I fix this?
regards,
AMi
1 Answers
Your Answer