MySQL Forums
Forum List  »  Triggers

Re: Create outfile trigger with appended text
Posted by: Peter Brawley
Date: June 17, 2016 03:06PM

> I need the text IT0312 to be what is the field called printer_name

Is this what you mean?

select ..., "IT0312" as printer_name, ... ;

> add these two lines of text the the file for our label printing software:
> %BTW% /AF=C:\labelfolder\ManualproductLabel.btw /D=%Trigger File Name% /PRN="IT0312" /R=3 /P %END%

You could add that at the end of the Select list as a Select constant, but it will still be in the Select list, probably not formatted correctly for your printer queue. IAC this is surely best done by software that can interact with the print job. You're spending how much time to save a couple of secs of printing time? Aren't they giving you enough to do?

Options: ReplyQuote

Written By
Re: Create outfile trigger with appended text
June 17, 2016 03:06PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.