update changes id key

[whackaxe]

can somene explain how/why "update" cahnges my primary key (called Id as most people do). i don't know if this can becoem a problem (well it hasnt for me yet) ?

[raf]

can you post an example update-statement that does that? I've never experienced that on any of the db-formats i've worked with.

It sure is unanted and problematic behaviour becost in most relational db's, the primary key is used to make links with other tables through primary key-foreign key constructs.