Query

[Gill]

Is there any query for I can check on item options ACCEPT FOOD STAMP FOR
THIS ITEM
I need to ad this option on all the SODA & GROCERY department.

--
Thank You
Harjit Singh SherGill /DBA
Altaville Market
324 South Main st po box 370
Altaville CA 95221
Tel : 209-736-1677
Fax; 209-498-3660
(e-mail address removed)

 

[convoluted]

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 -- hope this helps.....