Query


G

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)
 
Ad

Advertisements

C

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.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UK Invoicing queries 1
UK VAT on goods from EU query 1
Query 2
Query 3
UK Technical query- what constitutes a post balance sheet event? 16
CGT Query 4
Mortgage query??????? 2
query on 1099 3

Top