Cannot update identity column

QuestionsCannot update identity column
AMi asked 10 years ago


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?



1 Answers
Abu Ghufran answered 10 years ago

This issue is resolved in licensed version.
If using free, you might have to wait for next build of free version.

Your Answer

4 + 10 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?