473,498 Members | 37 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

1 New Member
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?
Sep 9 '10 #1
1 1375
magicwand
41 New Member
write a BEFORE UPDATE trigger that copies the old value(s) into a history table with identical structure (plus update - date)
Sep 12 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
5786
by: Alex | last post by:
Hello, I have a rather large table in MS SQL 2000 that I'm writing reports in Crystal from, but I'm unsure how to get the various data files (from different departments) into the table. Below...
4
19728
by: | last post by:
I'm a bit of a newby to creating update queries so I was hoping those more experienced could help with what should be a simple query. I do know to create backups and test on a test database first....
1
11104
by: avinash | last post by:
hi myself avi i am developing one appliacaion in which i am using vb 6 as front end, adodb as database library and sql sever 7 as backend. i want to update one table for which i required data from...
4
4140
by: rdraider | last post by:
I am looking for some assistance with an update query that needs to link 3 tables: This query ran and reported over 230,000 records affected but did not change the field I wanted changed, not...
1
5152
by: Kunal | last post by:
Hi, I need some help on writing an update query to update "UnitsSold" field in Products Table whenever I save a transaction. The transaction may contain several "Subtransactions", one for each...
4
3168
by: holmm | last post by:
Hi, First post so apologies if this sounds a bit confusing!! I'm trying to run the following update. On a weekly basis i want to insert all the active users ids from a users table into a...
2
4540
by: Neville MADDEN | last post by:
Good morning everyone, I'm producing an A97 database of Mining records. One of the tables has the map sheet references as SH/55-14. The other table has the references as SH55-17. I want to...
1
969
by: Davidsm | last post by:
Hi guys i am using a update query to replace data in a column in a table the column name is MO_EA and Measure. If MO_EA is Bond Alliance or Bond Alliance CT in need to update the Column MEASURE to be...
2
1689
zachster17
by: zachster17 | last post by:
Hello everyone, I'm having difficult getting an update query to work. What I'm doing is search a table with filenames against another table that has filename wildcards that search against the...
33
2628
by: mjvm | last post by:
HI, I have a main table (tblStudents) that holds students where the unique field is StudentID; and a related table (tblNotes) on a one-to-many relationship, where the unique field is NotesID, and...
0
7124
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7163
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7375
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
4904
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3090
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3078
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1416
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
651
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
287
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.