query help please


C

Craig Wood

I posted this on the forum, but thought I'd post it here too.

I need to add the words "dog food" to the extended description of every item
in my "Dog Food" Department. If someone could please help with a SQL query
so I wouldn't have to go into each item individually I sure would appreciate
it. I just recently purchased a Star TSP100 Future print receipt printer,
and it has the capability to print coupons at the end of the receipt
depending on key words you specify that show up on the receipt. Using the
extended description field to add keywords for the software to pick up on is
the best and easiest way I could think of achieving this since not all dog
foods have both dog and food in the description. Thanks in advance.
 
Ad

Advertisements

S

ScottM

I think I'll be able to help.

First: Backup your database, important when making any changes like this.

Okay, for the query, you'll need to know the Department ID for the
department in question. You can find this by doing something like this:

Select ID from Department where Name='dog food'

To update the extended description for items in that department:

UPDATE Item SET ExtendedDescription='dog food' where DepartmentID=(Whatever
the ID# was from the first query)

This will put the words 'dog food' into the extended description of all
items that are in that department.

Caution, be careful when doing updates like this
 
C

Craig Wood

That's awesome, thanks Scott. Don't worry, I'll be careful. I've run many
queries, I'm just not so smart as to know what to put in 'em. :)

Craig
 
J

Jeff @ Check Point Software

Who reads Forum messages?

Jeff
Check Point Software
Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS) =====================================================
You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to see and download the file attachment(s). If you are not using a reader, follow the link below to setup Outlook Express. Click on "Open with newsreader" under the MS Retail Management System on the right. http://tinyurl.com/75bgz
=====================================================

I posted this on the forum, but thought I'd post it here too.

I need to add the words "dog food" to the extended description of every item
in my "Dog Food" Department. If someone could please help with a SQL query
so I wouldn't have to go into each item individually I sure would appreciate
it. I just recently purchased a Star TSP100 Future print receipt printer,
and it has the capability to print coupons at the end of the receipt
depending on key words you specify that show up on the receipt. Using the
extended description field to add keywords for the software to pick up on is
the best and easiest way I could think of achieving this since not all dog
foods have both dog and food in the description. Thanks in advance.
 
M

MarcR

Jeff,
I just asked myself that same question and then read your post - hah


Marc
 
C

Craig Wood

I think you guys already know how I feel about THAT forum. Maybe we bitched
and yelled loud and long enough they were tired of hearing it and gave us
our beloved NG back. I don't know how long it'll last, but I for one am glad
it's back. I honestly don't know what I was thinking when I posted there
first. :)

Craig
 
Ad

Advertisements

M

MarcR

Craig,
It sounds like you are having fun with your new printer. How does the
cost and speed compare to the Epson TM series? I may have to try one
next time a replacement is due. The coupon thing sounds like a great
feature.

Marc
 
C

Craig Wood

Marc,

I like it. It prints pretty much as fast as the Epson using OPOS even though
I'm using Windows drivers. (thanks for the heads up Jeff). There is one
thing that has taken a little getting used to. Since I'm using windows
drivers, they control when the drawer pops instead of RMS. The difference is
you can specify certain times when to pop, or not pop, the drawer open. With
OPOS, the drawer will open when you enter opening or closing amounts, the
same with no sales. With windows drivers, the drawer opens when you print a
receipt. So that means it opens every time you run a CC sale, but won't when
you enter opening amounts, or do a no sale. The only way I've found around
it is to print a receipt for no sales, then the drawer opens. Is it the same
with Epson's windows drivers? I know you use them instead of OPOS.

Craig

MarcR said:
Craig,
It sounds like you are having fun with your new printer. How does the cost
and speed compare to the Epson TM series? I may have to try one next time
a replacement is due. The coupon thing sounds like a great feature.

Marc
 
C

Craig Wood

Marc,

I forgot to mention that they are comparably priced with Epson's. I also
save a lot of paper, even though I have to print receipts sometimes when I
don't want to, the windows drivers remove all the white space.

Craig

MarcR said:
Craig,
It sounds like you are having fun with your new printer. How does the cost
and speed compare to the Epson TM series? I may have to try one next time
a replacement is due. The coupon thing sounds like a great feature.

Marc
 
M

MarcR

The drawer control is the same with the Epson printers when using Windows
Printers. Sounds like I will try one next time I need a printer. Thanks for
the feedback.

Marc
 
C

Craig Wood

Glad to be of some help. I am in the process of creating my first coupon, so
as soon as it's in use I'll post back to let you know how it goes. It seems
pretty easy, except for the fact that I have to design my own coupon image.
I am really not the creative type.

Craig

MarcR said:
The drawer control is the same with the Epson printers when using Windows
Printers. Sounds like I will try one next time I need a printer. Thanks
for the feedback.

Marc
 
Ad

Advertisements

C

Craig Wood

Scott,

I just wanted to let you know that I just ran the query and it worked
perfectly. Thanks again for your help, it is greatly appreciated.

Craig
 
Ad

Advertisements

J

Jeff @ Check Point Software

Craig,

If you can change your drawer’s interface to USB, then plug the drawer into a USB port and install Star’s OPOS drivers for it. Then RMS will open the drawer only for the Tender Type you want.

Jeff

Check Point Software

Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS)

=====================================================

You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to see and download the file attachment(s). If you are not using a reader, follow the link below to setup Outlook Express. Click on "Open with newsreader" under the MS Retail Management System on the right. http://tinyurl.com/75bgz

=====================================================

Marc,

I like it. It prints pretty much as fast as the Epson using OPOS even though
I'm using Windows drivers. (thanks for the heads up Jeff). There is one
thing that has taken a little getting used to. Since I'm using windows
drivers, they control when the drawer pops instead of RMS. The difference is
you can specify certain times when to pop, or not pop, the drawer open. With
OPOS, the drawer will open when you enter opening or closing amounts, the
same with no sales. With windows drivers, the drawer opens when you print a
receipt. So that means it opens every time you run a CC sale, but won't when
you enter opening amounts, or do a no sale. The only way I've found around
it is to print a receipt for no sales, then the drawer opens. Is it the same
with Epson's windows drivers? I know you use them instead of OPOS.

Craig

MarcR said:
Craig,
It sounds like you are having fun with your new printer. How does the cost
and speed compare to the Epson TM series? I may have to try one next time
a replacement is due. The coupon thing sounds like a great feature.

Marc
 

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

Some Query Help Please 2
UK please help with my query :-( 2
SQL Query Help, Please 12
UK Invoicing queries 1
amend a PO with a query? Please help! 3
Query Help 7
Pension Query - advice please 8
SupplierID Query Help 3

Top