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

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






More information about the AccessD mailing list