Hibernate version: 1.2.0 beta1

Name and version of the database you are using: MS SQL Server 2005

I'm really new to all this database work so be easy with me.

I simply have a details view that when you hit the update linkbutton within it is supposed to update the entry. It only spits this error message when I change the key field but it won't throw it if I only change a regular field.

EX: the detailsview has 3 fields
Name (Key field and string) , Address (string), Enabled (bit).

If I change the Name it crashes.
If I change just the address or the enabled or both but not the name then it is fine.

I get this server error:

"SQL insert, update or delete failed (expected affected row count: 1, actual affected row count: 0). Possible causes: the row was modified or deleted by another user, or a trigger is reporting misleading row count."

I suspect it has to do with the mapping files because if i change the Name field to "any" for the unsaved-value then it saves fine but instead of just updating the record in the DB it adds another new record with the updated fields.

Not sure if this is enough to solve the problem but just be easy on me. Like I said, I'm really really new to this stuff.

AFAIK it is not allowed to change the value of primary key in NHIbernate.

Gert

Thanks for the reply.

I do understand that it won't let me change the primary key. So the question is how do I get around that. In essence how can I get it to update correctly?

Add a non-changeable surrogate primary key to the object.

Changeable primary keys are usually considered to be a bad design.

Gert