How do I reverse the following sequel query I recently ran in Store Operation Administrator : UPDATE item SET picturename = itemlookupcode + '.jpg' ?
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'
**** Please verify an answer, if it solves your problem. This will help others.
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.