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

I haven't missed any point.  Of course you set cascade delete off for these
scenarios.

>But for the purpose of automatic clean-up of otherwise completely useless
and orphan data, I have never seen cascade-deleting fail.

I don't have orphan data.  RI makes sure of that.

And useless data is not useless when it is first put in or it wouldn't be
there.  So you turn on cascade delete for the millisecond that useful data
becomes useless, delete the (now) useless data, then turn it back on?
Hmmm... my databases don't allow you to fiddle with that stuff with users in
the database (do they?).  I definitely need to study at your feet.

>At least it's not the way I entry unknown land. And I would make a backup
as the very first step. Then no one gets angry - not even yourself when you
make a mistake.

It's not you I worry about.  You are the very knowledgeable developer who of
course would do things right.  What I worry about are those very real people
out there who don't have a clue.  It is my job to do my best to protect my
data from you (easy) and from those unknown souls that are just connecting
to data they don't own to... oops... there goes my data cause they deleted
something they weren't supposed to.  I only set cascade delete on for...
they weren't supposed to... it's not my...

Sorry... I'll continue this discussion someday soon - after I've worked my
a** off figuring out how to get my data back.

<very big grin>

We live in an ever expanding, connected world.  There is very little data
that is always useless, that nobody ever cares whether it will be deleted,
and which every user out there has permission to delete.  But believe me,
whenever I find such data, I use cascade delete to delete it!

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: Sunday, February 02, 2003 3:47 PM
To: John W. Colby
Subject: Re: [AccessD] Cascade-delete (was: Estimating Help)


Hi John

I wonder why you constantly miss the point. For all those horror
scenarios you paint up, all of us - me, Jeanine, John B, Andy,
yourself and any responsible developer - would of course set
cascade-delete to off.

But for the purpose of automatic clean-up of otherwise completely
useless and orphane data, I have never seen cascade-deleting fail.

I have enough else to do than to recode tools already there.
Seems like you can join a club with Arthur and Drew on building delete
queries!

> I can now walk (or remote access) into your environment and wreak havoc
with
> your database, not having a clue how things relate to other things etc.
> Don't think for a minute it doesn't happen.  I am hired by the engineering
> office down the hall (or on the other side of the country).  You don't
even
> know I exist.  I delete your stuff.  You jump up and down, swear, shoot
your
> users, are arrested and hauled off to jail.  And I don't even know that
you
> are angry.

I hope this is a joke. At least it's not the way I entry unknown land.
And I would make a backup as the very first step. Then no one gets
angry - not even yourself when you make a mistake.

/gustav

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com