News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) How can i reverse this...

Microsoft Dynamics RMS (Archived)

How can i reverse this: UPDATE item SET picturename = itemlookupcode + '.jpg'

(0) Share

Report

Report

Posted on by Gord Cox

200

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

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Gord Cox 200 on at

Like (0)

Report

RE: How can i reverse this: UPDATE item SET picturename = itemlookupcode + '.jpg'

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.
Verified answer

Community Member on at

Like (0)

Report

RE: How can i reverse this: 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'

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,459 Super User 2025 Season 1

#2

Martin Dráb 233,066 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans