query help please

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.

Reply to
Craig Wood
Loading thread data ...

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

"Craig Wood" wrote:

Reply to
ScottM

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

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

Reply to
cptsoft

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

Marc

Reply to
MarcR

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

Reply to
Craig Wood

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

Reply to
MarcR

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

Reply to
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

Reply to
Craig Wood

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

Reply to
MarcR

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

Reply to
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

Reply to
Craig Wood

Reply to
cptsoft

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.