Re: [SQL] Table History

2004-12-17 Thread RobertD . Stewart
age- From: John DeSoi [mailto:[EMAIL PROTECTED] Sent: Friday, December 17, 2004 10:38 AM To: Richard Sydney-Smith Cc: [EMAIL PROTECTED] Subject: Re: [SQL] Table History On Dec 17, 2004, at 1:23 AM, Richard Sydney-Smith wrote: > I expect this has been done MANY times and I wonder if a general

Re: [SQL] Table History

2004-12-17 Thread John DeSoi
On Dec 17, 2004, at 1:23 AM, Richard Sydney-Smith wrote: I expect this has been done MANY times and I wonder if a general purpose trigger exists or if not then can someone point me to an example set of triggers? I'm not aware of a "general purpose" trigger for this. If you just want some extra

[SQL] Table History

2004-12-16 Thread Richard Sydney-Smith
Title: Message A database I maintain has a central transaction table ( FTRANS) I would like an second table FTRANS_IMAGE to maintain a historical view of ftrans. So if records in FTRANS are altered we can trace the effect of those changes in FTRANS_IMAGE.   I expect this has been done MANY