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

Gustav Brock gustav at cactus.dk
Wed Feb 5 05:56:01 CST 2003


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




More information about the AccessD mailing list