please help... multiple key table and merge

  • Thread starter Thread starter Aaron Lind
  • Start date Start date
A

Aaron Lind

I have a table with 3 keys, it is possible that the user may want to
change one of them. If the key is changed (let's say from 1 to 2) the
actual update to the database works fine. The problem is that when
the dataset gets back to the client and an attempt is made to merge
with the original dataset, an error is thrown:

"Failed to enable constraints. One or more rows contain values
violating non-null, unique, or foreign-key constraints."

Basically, the original data appears to assume the original key value
is 2 when it is really 1. It seems to me that I should be able to do
this. The row is in a modified state so the 2 value should not be
considered the current key. Any suggestions would be greatly
appreciated.

Aaron
 
I was just thinking. Am I over merging? Up to this point I have only
worked with Identity primary key tables. Is merge only necessary in
Identity key scenarios as well as merging different record sets
together?
 
Back
Top