1. Home
  2. Point-Of-Sale Software
  3. Mass Item Database Change

Mass Item Database Change

What SQL statement would be used to update every item in the database to turn on barcodes = code 128B ?

Reply to
Richard
Loading thread data ...

UPDATE Item SET BarcodeFormat = '7'

Rob

Reply to
Rob

Thanks Rob. How do you figure this out? Is there a resource available to me which I could use to answer this question myself? Seems everytime I have a database change need, I don't have the info needed to figure out the query.

Tnx aga> UPDATE Item

Reply to
Richard

You first need an understanding on Relational Database Management, if you already understand SQL and how tables releate to each other then you need to figure out how the tables are setup in RMS. If you download an evaluation of SQL Server 2000 you can install just the tools which includes Enterprise Manager or you can download the Lite version of EMS's MS SQL Manager for free.

formatting link
Rob

Reply to
Rob

Also, if you purchased your RMS through a partner, I would contact them to see if they have any docs on this that they can share w/ you. They should have something that shows the table structure for the Store and/or HQ database(s).

hth kev> Thanks Rob. How do you figure this out? Is there a resource available to me

Reply to
kskinne

For a lot of what you are asking we have added to both Store and HQ Misc Utilities Wizards that do these for you. If you want to get a demo version contact me.

Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk] CEO - Retail Realm

Reply to
Afshin Alikhani

If you would like to automate this process for all items (existing and new) consider our AutoGen add-in. You can define which barcode format you would like to set as the default. AutoGen information:

formatting link
can also download a 30 day trial to try out this feature.To place an order, contact your RMS reseller. Greg Digital Retail Solutions

begin 666 AutoGenMisc.GIF M1TE&.#EA`P+N`?

Reply to
Greg [DRS]

I do not know the number assigned to barcode format 128B, but if you can find that out, your statement would be (after backing up your database first):

UPDATE Item SET BarcodeFormat = 'x'

We used this when updating all of our barcodes to 128C where 8 was the variable used for that format.

Also, the Matrix Master is a great application which we use as provided by our partners via DRS.

Jocelyn

"Greg [DRS]" wrote:

Reply to
Jocelyn

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.