POS 2.0 upgrade from 1.0 - item pictures not linked to inventory i

Feb 25, 2007 2 Replies
J

We took pictures of 100's of inventory items and could see the pictures when we looked at the inventory items in POS 1.0. After upgrading to POS 2.0, pictures are still there in file manager in the proper "directory", but they are NOT linked to the inventory items.



We did create the pictures with names that match the item numbers, so a carefully constructed SQL update might do the trick, but I wonder whether this is a bug?



Can I get a sample SQL from anyone? (and instructions?) I have a lot of experience with SQL on mainframes, UNIX and Linux, but none on SQL server.


Vote
Twitter Facebook LinkedIn
J

JD,

I've been able to repro this issue, and I was able to repair the link using this query:

UPDATE [Item] SET [PhotoID] = [PhotoID] - 8021 + 100001 WHERE [PhotoID] >= 8021 AND [PhotoID] < 100001

I strongly recommend that you make a backup of your database first.

Also, if you use customer pictures you could use this query:

UPDATE [Customer] SET [PhotoID] = [PhotoID] - 8021 + 100001 WHERE [PhotoID] >= 8021 AND [PhotoID] < 100001

Please let me know if this helps.

- Jeff

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required