Question Status

Verified
Gord Cox asked a question on 14 Jul 2014 1:57 PM

How do I reverse the following sequel query I recently ran in Store Operation Administrator : UPDATE item SET picturename = itemlookupcode + '.jpg' ?

Reply
Verified Answer
ed boyer responded on 14 Jul 2014 4:37 PM

I hope you have a backup.  To reverse the update you need to restore that backup.

If you dont have a backup, the only thing you can do is default the values for the picturename field.

Update item Set picturename = '' where picturename =  itemlookupcode + '.jpg'

Ed Boyer

ed.boyer@esspos.com

www.esspos.com

https://www.linkedin.com/in/edboyer1

**** Please verify an answer, if it solves your problem.  This will help others.

Reply
Gord Cox responded on 15 Jul 2014 7:18 AM

Thanks Ed. This worked well for me as I only needed to reset to the default. By the way I do have 3 backups done daily....one can"t be to careful. Thanks again.

Reply
Verified Answer
ed boyer responded on 14 Jul 2014 4:37 PM

I hope you have a backup.  To reverse the update you need to restore that backup.

If you dont have a backup, the only thing you can do is default the values for the picturename field.

Update item Set picturename = '' where picturename =  itemlookupcode + '.jpg'

Ed Boyer

ed.boyer@esspos.com

www.esspos.com

https://www.linkedin.com/in/edboyer1

**** Please verify an answer, if it solves your problem.  This will help others.

Reply