[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