Subject Re: [IBO] Interbase / Delphi stored procedure
Author Jason Wharton
Don't proliferate tables. This isn't healthy as you have to do a backup and
restore every 256th major metadata change.

Use a current table and a single archive table and add a column to the
archive table that will distinguish the periods.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: <Wayne@...>
To: <>
Sent: Tuesday, February 13, 2001 10:11 AM
Subject: [IBO] Interbase / Delphi stored procedure

> Hi all,
> I have a history table and a current table in my app. The fields are
> identical in each.
> the fields are:
> shift, date, employee
> combined they are unique.
> say my current table is February2001_rotation_tbl. Now it is nearing
> the end of february and the march rotations need to be done. I want
> 1> a stored procedure to copy all the data from
> february2001_rotation_tbl to the history table
> and then
> 2> afterwards delete all the records in february2001_rotation_tbl
> and
> 3>rename february2001_rotation_tbl as March2001_rotation_tbl.
> Can this be done? and if so how? I have to consider that this table
> will have foreign keys in it and will be refered to by other tables.
> I may have to rather have a tablename that remains the same and
> doesn't change, say like monthy_rotation_tbl ???
> Wayne Bruton