Query

Hi Gill

Backup the database first and if you can, run these after hours.

First jot down the department ID values by connecting to your db and running SELECT * FROM DEPARTMENT

-- jot down the ID values for soda and groceries

Then check the items you are about to update by running SELECT DEPARTMENT, ITEMLOOKUPCODE, DESCRIPTION, FOODSTAMPABLE FROM ITEM WHERE DEPARTMENTID IN (X,Y)

--replace X and Y with the soda and grocery dept ID values

-- jot down any odd items that shouldn't be updated - you can fix these later

-- a "foodstampable" of no check mark ("0") means do not accept food stamps, if check marked ("1") it means item already set to accept food stamps

Then update the item table by running UPDATE ITEM SET FOODSTAMPABLE = 1 WHERE DEPARTMENTID IN (X, Y)

--replace X and Y with the ID values of the soda and groceries depts.

remember to backup your database -- h> Is there any query for I can check on item options ACCEPT FOOD STAMP FOR > THIS ITEM