Re: Needs help urgent..

From: Bhooshan Prabhu <bhooshan.s.prabhu_at_orbitech.co.in>
Date: 17 Sep 2002 04:18:28 -0700
Message-ID: <16584988.0209170318.c038f58@posting.google.com>

Hello,

Would it be possible for you to do the following; 1. Instead of updating the Primary Key, Insert a new record in Master using

new values for PKey and existing non-pk columns from the Old PKey record. 2. Update the detail table ref key columns 3. Delete the old PKey record from Master.

regards
Bhooshan

priya_at_starcomsoftware.com (priya) wrote in message news:<1ae23258.0209162213.66a85c16_at_posting.google.com>...
> Hi..
>
> I want to update two tables which have ref. integrity constraints among them.
> When I'm updating master table's primary key it gives me error as
>
> 'Integrity constraint violated .. child record found'
>
> When I'm updating detail table's ref. key gives me error as
>
> 'Integrity constraint violated.. no parent record found'
>
> Is there any way to solve above problem other than enabling / disabling
> constraints before updattion ?
>
> Thanks,
> Priya
Received on Tue Sep 17 2002 - 06:18:28 CDT