1. Home
  2. Point-Of-Sale Software
  3. Could you check this SQL Statement?

Could you check this SQL Statement?

I want to change item number from 001199 to 001199CS. But I can't do that make new item and download. Because this item number(001199) has very important movement history. So. I want to Change this item number.

Anyway, I do Worksheet 51. Sql : Upate itemlookcupcode ='001199cs' Where ItemLookupCode='001199'

Is it right or wrong? Could you check this statement?

Thank u

Reply to
Judy
Loading thread data ...

I don't understand why you can't change the lookupcode. The History is tied to Item.ID, which is an internal number that you never see and can't change. You just want to change Item.ItemLookupCode, which is a Varchar value that you CAN change. As long as the item has already been syncronized between HQ and Store, it is going to be linked by HQ.Item.ID = Store.Item.HQID. You can change the Lookup Code at HQ then use a

250 worksheet to send the change to the store.

Glenn Adams Tiber Creek C> I want to change item number from 001199 to 001199CS.

Reply to
Glenn Adams [MVP - Retail Mgmt]

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.