J
John Smith
If I have 2 tables in a dataset that participate in a parent-child
relationship based on a multiple-column key, how can I change the value of
those key column values in both tables?
The problem is, I can't change the parent before the child, because of the
key constraint. I can't change the child before the parent because the child
needs a matching parent. I can create a new parent with the new values,
change the child, and then delete the old parent. This works if I am only
changing 1 column. However if I need to change multiple columns the update
fails after changing the first column because at that point in time there is
no matching parent. I hope this is clear!
Help!
relationship based on a multiple-column key, how can I change the value of
those key column values in both tables?
The problem is, I can't change the parent before the child, because of the
key constraint. I can't change the child before the parent because the child
needs a matching parent. I can create a new parent with the new values,
change the child, and then delete the old parent. This works if I am only
changing 1 column. However if I need to change multiple columns the update
fails after changing the first column because at that point in time there is
no matching parent. I hope this is clear!
Help!