Re: modelling history in a database
From: stu <smcgouga_at_nospam.co.uk>
Date: Fri, 14 Feb 2003 09:23:31 -0000
Message-ID: <b2iclb$lkm$1$8302bc10_at_news.demon.co.uk>
Date: Fri, 14 Feb 2003 09:23:31 -0000
Message-ID: <b2iclb$lkm$1$8302bc10_at_news.demon.co.uk>
"Jason" <pmorrison_at_4lpi.com> wrote in message
news:cf188409.0302131022.3be0e1ad_at_posting.google.com...
> Jan Marten Visser <jan.marten.visser_at_virgil.nl> wrote in message
news:<3E4A2B18.C729DD29_at_virgil.nl>...
> Second, you could create a table Change that has fields for the table,
> field, old data, new data and date of change.
>
I like that idea! Have you tried it in practice? Does anybody else have any comments on this suggestion?
Cheers
Stu
Received on Fri Feb 14 2003 - 10:23:31 CET