Update primary key und foreign key with updategram

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello,
I have a problem with updating primary- and foreign-key with an updategram.
My Tables

cd (cdID primary key, name string)

song(songID, cdID foreing key, title)
The tables have data.


When I want to update a cdID in the table cd with an updategram like this:
<before>
<cd cdID="1"/>
</before>
<after>
<cdID="11"/>
</after>

The Erroris:
UPDATE statement conflicted with REFERENCE constraint 'song_fk_1'. I know
there is a problem, but how can i update a primary-key and the foreign-key
with an updategram?


Thx
Alex G.


.