Re: delete cascade
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 23 Apr 2007 01:04:25 GMT
Message-ID: <tCTWh.27145$PV3.282312_at_ursa-nb00s0.nbnet.nb.ca>
>
> I'm guessing that you mention rva's so that there can be no chance that
> a product would be permitted to only partially complete the operation,
> and leave some items dangling, whereas some products might allow a
> series of delete statements to be interrupted?
Date: Mon, 23 Apr 2007 01:04:25 GMT
Message-ID: <tCTWh.27145$PV3.282312_at_ursa-nb00s0.nbnet.nb.ca>
> Bob Badour wrote:
> ...
>
>> Would it suffice to declare the view using the RVA as above and then >> project away the RVA?
>
> I'm guessing that you mention rva's so that there can be no chance that
> a product would be permitted to only partially complete the operation,
> and leave some items dangling, whereas some products might allow a
> series of delete statements to be interrupted?
I mention it because it would fully disclose the data to be deleted, which is the invoice and the associated items. Received on Mon Apr 23 2007 - 03:04:25 CEST