We recently implemented RMS with a new database and discovered, much to our chagrin, that one of our categories was misspelled--Mediterannean (not Mediterranean, as it should be). Is it possible to make global database changes to correct such problems through a query, or is there another technique that you'd recommend? We have some other text type changes to make, as well, that would be more easily done in a table rather than record by record.
MMS,
No biggie.
If running SO, change it in SO Manager | Database | Departments & Categories| . The wordage is only stored in the Category table, the relationship is by an internal, unseen, number.
If you're running HQ, instead, make the change in HQ Manager | Maintenance mode | Database | Department & Categories and then run a 204 worksheet to all stores.
Thank you for your reply and your help.
Just to take the idea to the next step, what if the alternati> MMS,
MMS,
That will be an issue with old receipts if the info printed on them as they cannot be changed, but a change now will affect all future receipts.
There are different routines for the different programs, are you using SO or HQ? If SO, the changes are made immediately, with HQ you will need to do a
250 or some other worksheet.If you had mispelled something in the description field of many items, you could run an SQL Query from SO Administrator ( Or HQ Administrator )
File/Connect Enter your database conection information Query/New
UPDATE Item Set Description = Left(replace(Description,'Mediterannean', 'Mediterranean'), 30) WHERE Description Like '%Mediterannean%' Query/Run
If this were in HQ, you would still need to run a 250 worksheet to send the updated descriptions to the stores.
The Left(..., 30) part of the statement above is to trim the description to fit the database field in the event that you are replacing with a longer string that you are matching - not an issue in this case...
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.