dbTalk Databases Forums  

Oracle Report using printer code

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Oracle Report using printer code in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
kengheng@gmail.com
 
Posts: n/a

Default Oracle Report using printer code - 03-11-2009 , 02:29 AM






Dear All, I wish to send printer code to epson lq 590 to print the
barcode using the printer built-in barcode font. How would I do that
in report ?

Thanks.

Reply With Quote
  #2  
Old   
Malcolm Dew-Jones
 
Posts: n/a

Default Re: Oracle Report using printer code - 03-11-2009 , 01:29 PM






kengheng (AT) gmail (DOT) com wrote:
: Dear All, I wish to send printer code to epson lq 590 to print the
: barcode using the printer built-in barcode font. How would I do that
: in report ?

: Thanks.

Never used this myself, but a Field has two properties called "Printer
Code Before" and "Printer Code After".

I think you push the escape sequences of the printer into them.

So, for example, if <ESC>[F3 turns on font 3 (that's a made up sequence,
and also I am pretending 3 is the barcode font), then put those 4 bytes
into "Before". Then those bytes are send just before the value is sent
and the value will print in the barcode font.

How to get the escape sequence? Perhaps as follows: Read the printer
manual (the easy part). Then use some editor that allows you to control
what bytes you use. Then cut and paste that string into the property.

If your editor doesn't give you that kind of control, then perhaps
something like perl -e "print chr(27),chr(1),chr(2)" > temp.tmp, then use
notepad to open that file and cut/paste the contents into the field.

-- All guess work, having never done this myself. --


Reply With Quote
  #3  
Old   
kengheng@gmail.com
 
Posts: n/a

Default Re: Oracle Report using printer code - 03-14-2009 , 12:26 AM



I've tried using the printer code from the epson manual and create a
prt file, I can get the output to be set to bold or italic, however it
is can get the barcode printed. May be using barcode true type font in
Oracle Report is the better way, rather then using the manufacturer
printer code....

On Mar 12, 3:29*am, yf... (AT) vtn1 (DOT) victoria.tc.ca (Malcolm Dew-Jones)
wrote:
Quote:
kengh... (AT) gmail (DOT) com wrote:

: Dear All, I wish to sendprintercodetoepsonlq 590 to print the
:barcodeusing theprinterbuilt-inbarcodefont. How would I do that
: in report ?

: Thanks.

Never used this myself, but a Field has two properties called "PrinterCodeBefore" and "PrinterCodeAfter".

I think you push the escape sequences of theprinterinto them.

So, for example, if <ESC>[F3 turns on font 3 (that's a made up sequence,
and also I am pretending 3 is thebarcodefont), then put those 4 bytes
into "Before". *Then those bytes are send just before the value is sent
and the value will print in thebarcodefont.

How to get the escape sequence? *Perhaps as follows: Read theprinter
manual (the easy part). *Then use some editor that allows you to control
what bytes you use. *Then cut and paste that string into the property. *

If your editor doesn't give you that kind of control, then perhaps
something like *perl -e "print chr(27),chr(1),chr(2)" > temp.tmp, then use
notepad to open that file and cut/paste the contents into the field.

-- All guess work, having never done this myself. --


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.