Jeanine Scott
jscott at mchsi.com
Sat Feb 1 14:37:01 CST 2003
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