[AccessD] 2 Questions

Andy Lacey andy at minstersystems.co.uk
Wed Mar 10 12:52:05 CST 2010


Ooh we haven't had a good rant-thread for ages. Makes me quite nostalgic.
Just like old times. Go guys.

Andy

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 10 March 2010 17:37
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] 2 Questions


Hi Max

This may have been the case for you but it is not so in general.
Cascade-delete does not delete all your data except if all tables are linked
back to one single top-level table from which you "just happen" to delete
all records.
And should you have set it up to do so, it would be for a purpose, and it
will not delete the records without the usual warning.

Cascade-updates and cascade-deletes are excellent tools. Just learn to ride
them. It isn't hard.

/gustav


>>> max.wanadoo at gmail.com 10-03-2010 18:14 >>>
...and if your very lucky, it will go on  and delete your whole data...all
without a so much as bye your leave.  Then it will be every so nice and
clean.

Great stuff these switches - not!

Be lazy at your peril!!

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, March 10, 2010 5:00 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] 2 Questions

 > That's the beaty of cascade-deletes - the perfect clean-up tool!

ROTFL.  Indeed!

John W. Colby
www.ColbyConsulting.com 


Gustav Brock wrote:
> Hi John
> 
> That's the beaty of cascade-deletes - the perfect clean-up tool!
> 
> /gustav
> 
> 
>>>> jwcolby at colbyconsulting.com 10-03-2010 16:09 >>>
>  > As for how "dangerous" cascade-deletes are, it is not different 
> from any other action that alters or deletes data in the database.
> 
> Well... I disagree of course.  The problem is that cascade deletes 
> deletes EVERYTHING down to the last great-great-great-great grandchild 
> record (assuming Cascade delete everywhere).  That is pretty darned
dangerous.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list