[AccessD] Cascade-delete (was: Estimating Help)

John W. Colby jcolby at colbyconsulting.com
Sat Feb 1 14:43:00 CST 2003


Some of us are just luckier than others I guess.  Never had a user rip the
guts out of your database by trying to delete a client that they "weren't
doing business with" at the moment.

I should have such users!  ;-)

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Jeanine Scott
Sent: Saturday, February 01, 2003 3:36 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Cascade-delete (was: Estimating Help)


I agree. I have used Cascade delete on in almost all relationships and have
not once had an "uh-oh" issue. I haven't found a use for the update either!

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Saturday, February 01, 2003 12:56 PM
To: Arthur Fuller
Subject: Re: [AccessD] Cascade-delete (was: Estimating Help)

Hi Arthur

> .. I would never be so foolish as to turn cascade-delete on anywhere
> in any serious database :-)

That's a pity 'cause that's a very powerful tool!

Of course, as with fire and other potential dangerous tools, you must
know what you're doing and take your precautions.
Most listers, I'm sure, will vote with me that you indeed know what
you are dealing with, and I'm under the impression that you are a
frequent user of database modelling tools - so what's the trouble?

Before someone jumps on me with some horror story of unintended
deleted records let me stress that there are many (trivial) cases
where cascade-delete must be avoided; but for automatic cleaning of
linking tables or subtables it's a wonderful tool set to force with
zero code.

(Cascade-update is another story. I've never found a use for that
except when using natural keys which I avoid by all means.)

/gustav

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

_______________________________________________
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