John W. Colby
jcolby at colbyconsulting.com
Wed Feb 5 07:54:00 CST 2003
And this thread had almost died! 8~( 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 Gustav Brock Sent: Wednesday, February 05, 2003 6:55 AM To: Arthur Fuller Subject: Re: [AccessD] Cascade-delete (was: Estimating Help) Hi Arthur > Speaking only for myself, I use cascade frequently delete, wherever it's > appropriate. When I began this thread, I didn't mention cascade delete at > all. I very specifically said "rows disappearing from reports" -- not from > tables. This was an RI issue, not a cascade issue. However, since I have > been known to rant, carry on :-) Hmmm ... nice try. And it brought some relief. But [picky mode on] you did start the thread - I couldn't read this in more than one way: > I didn't mean that the rows were disappearing, but rather that they > disappeared from reports, since their FK referents were gone. I would never > be so foolish as to turn cascade-delete on anywhere in any serious database > :-) I restored an old copy with the deleted employees, then imported the > rows and restored sanity to the db. /gustav _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com