Thanks for all of you. I will test the suggestions and then reply.
CPK
--
Keep your Environment clean and green.
On Fri, Apr 18, 2008 at 8:13 AM, Peter Brawley <[EMAIL PROTECTED]>
wrote:
> CK,
>
> > How can we manage the history of changed rows in the database.
> >
>
> Point-in-time architecture. For a bit of discussion see
> http://www.artfulsoftware.com/infotree/tip.php
CK,
How can we manage the history of changed rows in the database.
Point-in-time architecture. For a bit of discussion see
http://www.artfulsoftware.com/infotree/tip.php?id=547
PB
-
C K wrote:
Hi all.
How can we manage the history of changed rows in the database. I have some
idea
C K wrote:
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not yet implemented. By using triggers to make a copy of the row
being changed to the another table in the same db. Is there any way to only
save the changed fields data and field name? Any
,
KEY (key_from_table),
field_1 ?? ,
field_2 ??,
...
field_n ??
I don't know a way of copying over every field accept long-hand in the
triggers.
Hope this is useful...
Ben
C K wrote:
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not ye
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not yet implemented. By using triggers to make a copy of the row
being changed to the another table in the same db. Is there any way to only
save the changed fields data and field name? Any other idea