Re: FN-FORUM: Suggestions please

date posted 15th August 2003 16:26

If the database is on a windows box, I would write a service that calls a
stored procedure. Otherwise run a program from a cron job that calls a
stored procedure.

Regards
Keith
www.gpthame.com & www.whirlingdervishes.com
.

----- Original Message -----
From: "PAMELA WHITTAKER" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Friday, August 15, 2003 5:15 PM
Subject: FN-FORUM: Suggestions please


>
> Hi,
> I am writing a timesheet at the moment and I want to make sure that
> noting over 5 years old is kept on the database. The only way I can think
of
> is going through and deleting everything over five years old every time
> someone logs in to the system which could be more than once a day.
> especially on a Friday. Can anyone think of a way of only doing it once a
> day please.
>
> Thanks
> Pam
>
>
> '
>
> NTMail K12 - the Mail Server for Education
>
> ==========
> redmail.com - webmail with a difference!
> 10Mb for just GBP 9.99 a year. Launch special 1Gb for GBP 99.99 a year
> IMAP, POP3, Spam Filtering and Anti Virus as standard.
> Visit http://www.redmail.com/?fl-signup to join.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>