Re: Barcode in SQR

First, I'm sure that you mean SQL. Second, printing barcode is usually the function of the printer (although there is software that will produce it). For a printer that has the capability of printing barcode, the following steps are taken:

1. Send control codes to printer (a.k.a. escape sequence) telling the printer that the following is to be printed in barcode.
2. Send data to be printed. the printer will covert your numeric string into the necessary bars.
3. send another control code that says I'm done printing barcode.

The "number/letters" that you send can be any column from the database. So..

     spool on
     select ascii({escape sequence to turn on barcode}) ||
      product_number || 
      ascii({escape sequence to turn off barcode}) from ....;
     spool out

That sould get you started.

Keith Hilgeman
Computer Sciences Corp
Heidelberg, Germany
hilgeman_at_heidelberg-emh2.army.mil Received on Fri Sep 30 1994 - 09:03:54 CET