Re: delete cascade

paul c wrote:

> Bob Badour wrote:
>

>> paul c wrote:
>>
>>> I sometimes wonder why the above noun used in place of an adjective 
>>> is needed.    When the table/relation definition of a line item 
>>> references an invoice number can it mean anything other than that the 
>>> line item doesn't exist unless the invoice exists?  Ie., why 
>>> shouldn't delete always mean so-called "cascade"?
>>>
>>> (just trying to keep Marshall interested.)
>>
>>
>> Because some times it means: "If a line item exists, the invoice must 
>> also exist."

No. One states that deleting the invoice automatically deletes any items that exist. The other states that one may not delete an invoice when any items exist. Received on Mon Apr 16 2007 - 14:56:51 CEST