Re: deleting the master but not the detail

It seems like 3 vs 1 so you win :)
I'll drop the constraint and verify the integrity of the new records manually

tanks


>
> On Thu, Jul 17, 2008 at 10:52 AM, Douglas McNaught  wrote:
>> On Thu, Jul 17, 2008 at 12:11 PM, Ismael ....  wrote:
>>>
>>> hi
>>> I have one of those master-detail relationships here and I need to be able
>>> to delete the master but leave the details untouched
>>
>> Then remove the referential integrity constraint, since it's obviously
>> incompatible with your business requirements.
>
> Generally I'd agree, but it might be useful to set the child record
> referencing id field to NULL in this circumstance.

_________________________________________________________________
Tenemos lo que búscas…JUEGOS.
http://club.prodigymsn.com/