1. Home
  2. Point-Of-Sale Software
  3. POS 2.0 upgrade from 1.0 - item pictures not linked to inventory i

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

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.

Reply to
JD
Loading thread data ...

Reply to
HARJIT SHERGILL

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

Reply to
Jeff Blucher [MSFT]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.