Subject Re: Purging Old Records
Author Svein Erling Tysvær
--- In, "Graeme Bruton" wrote:
> Hi All
> Is there any way to tell Firebird to purge records that are older
> than a specified date? What I'm thinking is that we would write the
> database out to a DVD, purge the old records and keep the database a
> reasonable size. Then repeat the performance once every 6 or so
> months, or do it monthly going back 6 months.
> Any ideas?
> Graeme

If you have a field named e.g. Last_Updated, then there's nothing
stopping you from writing a program that exports/transfers the data
and then do a

DELETE FROM Graeme_Table WHERE Last_Updated < Current_Date - 183

Though according to, purge is stronger than delete and
should be unrecoverable, so you may want to skip the export/transfer
bit... ;o)