Re: Trigger Question

Sure, a trigger would do this fine, 's long as you have a unique key you can use to ident the record, or if you are just looking for audit data, just shove it into another table, thats what we do brett da_cohen@netvision.net.il wrote: > > Hi, > > Is there anyway for duplicate a record, using triggers, from one table > to another table in case of any changes in the first table? > > Let say I have a table 'A' with two fields and another table, 'A_back' > with the exact two fields. > When there is a change in one of the records of table 'A', I would like > to copy the record with it's new values to table A_back. > > Thanks > > Sent via Deja.com > http://www.deja.com/ -- ----------------------------------------------------------------- Brett's 12th law of UNIX administration... People tend not to react well when they lose control over their computers. Typically, it brings out the worst in them ... ----------------------------------------------------------------- Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. Tel. +27 31 717 4000 Direct. +27 31 717 4146 Fax. +27 31 717 4001 ----------------------------------------------------------------- The little voices are talking to me again, telling me to reach for a keyboard and type rm -rf /* last week they had me rm -rf `echo $MANPATH | sed 's/:/ /g'` now I fear I have no answers -----------------------------------------------------------------