inmate problem

[Tammy B.]

I have a database that keeps track of inmates. When an inmate escapes, i
have a way to lookup the name of the guard who was supposed to be guarding
the escapee. The problem is that when the inmate escapes, his name gets
deleted from the database, so I have no way to tie his name a guard. Is
there anyway to retreieve the last 7 inmate names so I can punish or fire
the guard(s).
Extremely Urgent.

[only_me]

Why are they deleted, surely they should be flagged as Escaped (or flagged
as 'deleted') to keep any joins etc valid.

So your delete procedure should set a flag in db rather than actually delete
the record, you will then need to change your display code to ensure records
flagged as deleteed are not normally displayed.

Then maybe after 6 months or so assuming he has evaded re-capture and thus
achived ' got out of jail free' status the record could be purged then.

"Tammy B." <Tb@stinkylips.com> wrote in message
news:e45DrS2TDHA.2264@TK2MSFTNGP11.phx.gbl...

> I have a database that keeps track of inmates. When an inmate escapes, i
> have a way to lookup the name of the guard who was supposed to be guarding
> the escapee. The problem is that when the inmate escapes, his name gets
> deleted from the database, so I have no way to tie his name a guard. Is
> there anyway to retreieve the last 7 inmate names so I can punish or fire
> the guard(s).
> Extremely Urgent.
>
>

[middletree]

On our Intranet, we flag an employee as Active (if they still work here) or
Inactive (if they have resigned or been terminated). That way, their
records are still in the database after they leave, so that other items
associated with them don't get affected. This is pretty much want you want
to do. Add a field denoting whether or not they have escaped, or some
similar thing.

And I don't think you should necessarily fire the guard. It's not always his
fault. I'm no expert, but I saw Shawshank.


"Tammy B." <Tb@stinkylips.com> wrote in message
news:e45DrS2TDHA.2264@TK2MSFTNGP11.phx.gbl...

> I have a database that keeps track of inmates. When an inmate escapes, i
> have a way to lookup the name of the guard who was supposed to be guarding
> the escapee. The problem is that when the inmate escapes, his name gets
> deleted from the database, so I have no way to tie his name a guard. Is
> there anyway to retreieve the last 7 inmate names so I can punish or fire
> the guard(s).
> Extremely Urgent.
>
>

[jason kennedy]

perhaps you could get the inmates to complete an online questionnaire
attributing blame for their escape, before they crawl along their secret
tunnel/negotiate razor wire fence/make rendezvous with hijacked helicopter
(delete as applicable)

:)

Jason

"middletree" <middletree@htomail.com> wrote in message
news:ebMhBw5TDHA.2308@TK2MSFTNGP12.phx.gbl...

> On our Intranet, we flag an employee as Active (if they still work here)

or

> Inactive (if they have resigned or been terminated). That way, their
> records are still in the database after they leave, so that other items
> associated with them don't get affected. This is pretty much want you

want

> to do. Add a field denoting whether or not they have escaped, or some
> similar thing.
>
> And I don't think you should necessarily fire the guard. It's not always

his

> fault. I'm no expert, but I saw Shawshank.
>
>
> "Tammy B." <Tb@stinkylips.com> wrote in message
> news:e45DrS2TDHA.2264@TK2MSFTNGP11.phx.gbl...

> > I have a database that keeps track of inmates. When an inmate escapes,

i

> > have a way to lookup the name of the guard who was supposed to be

guarding

> > the escapee. The problem is that when the inmate escapes, his name gets
> > deleted from the database, so I have no way to tie his name a guard. Is
> > there anyway to retreieve the last 7 inmate names so I can punish or

fire

> > the guard(s).
> > Extremely Urgent.
> >
> >

>
>

[Phillip Windell]

Since they get deleted from the DB when they escape, maybe the inmates
wrote it :)

Not only do they get to run the asylem, they get to design the
computer system too! :)

Just kidding, Tammy! Relax,...I just couldn't pass that up.

--

Phillip Windell [CCNA, MVP, MCP]
[email]pwindell@wandtv.com[/email]
WAND-TV (ABC Affiliate)
[url]www.wandtv.com[/url]

"jason kennedy" <jason@pinhut.com> wrote in message
news:#yM1Tf6TDHA.2460@TK2MSFTNGP10.phx.gbl...

> perhaps you could get the inmates to complete an online

questionnaire

> attributing blame for their escape, before they crawl along their

secret

> tunnel/negotiate razor wire fence/make rendezvous with hijacked

helicopter

> (delete as applicable)
>
> :)
>
> Jason
>
> "middletree" <middletree@htomail.com> wrote in message
> news:ebMhBw5TDHA.2308@TK2MSFTNGP12.phx.gbl...

> > On our Intranet, we flag an employee as Active (if they still work

here)

> or

> > Inactive (if they have resigned or been terminated). That way,

their

> > records are still in the database after they leave, so that other

items

> > associated with them don't get affected. This is pretty much want

you

> want

> > to do. Add a field denoting whether or not they have escaped, or

some

> > similar thing.
> >
> > And I don't think you should necessarily fire the guard. It's not

always

> his

> > fault. I'm no expert, but I saw Shawshank.
> >
> >
> > "Tammy B." <Tb@stinkylips.com> wrote in message
> > news:e45DrS2TDHA.2264@TK2MSFTNGP11.phx.gbl...

> > > I have a database that keeps track of inmates. When an inmate

escapes,

> i

> > > have a way to lookup the name of the guard who was supposed to

be

> guarding

> > > the escapee. The problem is that when the inmate escapes, his

name gets

> > > deleted from the database, so I have no way to tie his name a

guard. Is

> > > there anyway to retreieve the last 7 inmate names so I can

punish or

> fire

> > > the guard(s).
> > > Extremely Urgent.
> > >
> > >

> >
> >

>
>

[Phillip Windell]

I guess they figured out how to encapsulate themselves and "tunnel
through a firewall" :)

"John Beschler" <giles@geewhiz.com> wrote in message
news:021e01c35201$632db290$a101280a@phx.gbl...

> Seems to me if you have that many inmates escaping,
> perhaps the data integrity is NOT your biggest problem! :)
>
> (Sorry, I couldn't resist.)
>
>

> >-----Original Message-----
> >Why are they deleted, surely they should be flagged as

> Escaped (or flagged

> >as 'deleted') to keep any joins etc valid.
> >
> >So your delete procedure should set a flag in db rather

> than actually delete

> >the record, you will then need to change your display

> code to ensure records

> >flagged as deleteed are not normally displayed.
> >
> >Then maybe after 6 months or so assuming he has evaded re-

> capture and thus

> >achived ' got out of jail free' status the record could

> be purged then.

> >
> >"Tammy B." <Tb@stinkylips.com> wrote in message
> >news:e45DrS2TDHA.2264@TK2MSFTNGP11.phx.gbl...

> >> I have a database that keeps track of inmates. When an

> inmate escapes, i

> >> have a way to lookup the name of the guard who was

> supposed to be guarding

> >> the escapee. The problem is that when the inmate

> escapes, his name gets

> >> deleted from the database, so I have no way to tie his

> name a guard. Is

> >> there anyway to retreieve the last 7 inmate names so I

> can punish or fire

> >> the guard(s).
> >> Extremely Urgent.
> >>
> >>

> >
> >
> >.
> >