some of my data is getting overwritten by the update query i want to save my old data

Asharf

New Member

Join Date: Sep 2010

Posts: 1
#1

some of my data is getting overwritten by the update query i want to save my old data

Sep 9 '10, 09:05 AM

Some of my data is getting overwritten by the update query.
I want to save my old data.

So how can i save my old data?

Last edited by Frinavale; Sep 9 '10, 02:03 PM. Reason: Added the description of the problem to the thread so that the question makes sense.
Tags: None
magicwand

New Member

Join Date: Mar 2010

Posts: 41
#2

Sep 12 '10, 02:15 PM

write a BEFORE UPDATE trigger that copies the old value(s) into a history table with identical structure (plus update - date)
Comment

Comment