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/