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