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.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <Wayne@...>
To: <IBObjects@yahoogroups.com>
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 ???
>
> TIA
>
> Wayne Bruton
>
>
>
>
>
>