Generating a Bar Code

  • mivica

    SSC Enthusiast

    Points: 155

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/mivica/generatingabarcode.asp

  • gerardj

    SSC Rookie

    Points: 43

    all i can say is.... WOW!!!

  • Vasc

    SSCarpal Tunnel

    Points: 4623

    Nice Job

    I just wnat to point out a few things:

    - a true type font is needed to reproduce the BarCode (in this case is used Code39 wich is free)(the actual text has to be inside * signs)

    -the font should be available on the machine that wants to do the printing

    -with this font you won't be able to print EAN13 BarCodes (or other symbologies)

    -the X size of a BarCode is decided by the thikness of each bar used to reproduce the barcode ( for this font the X size is the same when you have the same no of chars for others can vary a lot) 

    - sp_makewebtask can be used

    - table variable can be used instead of temp


    Kindest Regards,

    Vasc

  • owenzhang1977

    Newbie

    Points: 9

    this is a nice procedure

    but in my sql server i can not running normal

    if any font need to install?

    draw out 2 files

    c:\code.eot

    c:\psocode39.html

    way i can not view the bar code ,

    Whom know please advise me.

    Many thanks!

    BestRegards.

    Owen

  • ivica

    Right there with Babe

    Points: 727

    You don't need to install any fonts. Check IE version. Those 2 files are OK. Start html file from c: drive and that's it!

  • Harold Espinosa Ch.

    Grasshopper

    Points: 13

    I think it is a very good Routine.

    I have one question.

    How can i print some label with a Vertical barcode  and some text using this routine?

     

     ej.

     

     --------------------------------------------

    |    BarCode (Horizontal)                              |

    |    N                                                       |

    |     a                                                       |

    |     m                                                      |

    |     e                              barcode(vertical)  |

    -----------------------------------------------

    hech1@yahoo.com

    Harold Espinosa

  • Maria Iqbal Mir

    Grasshopper

    Points: 19

    im completely new to this bar code thing. i have downloaded the file on the page but im not sure what to do now? in which db should i run exeucute the .sql file and what am i supposed to do then?

    pleeeeeeeeeeease let me know as soon as possible

    thank you

  • Matt Boiteau

    SSC-Addicted

    Points: 461

    How can we edit the binary string, so we can use this code off of our Intranet and not just C:??  I like this Font better that you are using then the free 'Free 3 of 9 Extended' that you can find on the Intranet. 

    To make a vertical barcode, here is a style..

    <html><head>

    <STYLE TYPE="text/css">

    <!-- @font-face {font-family: Free 3 of 9 Extended;font-style:  normal;font-weight: normal;src: url(BarCode.eot);}

    .verticaltext{writing-mode: tb-rl;}

    P.page { page-break-after: always; }-->

    </STYLE>

    </head>

    <body>

    ..............

    <td class="verticaltext" nowrap ><font face="Free 3 of 9 Extended" size="5">*$%Q1%$*</font></td>

     

  • anthony.cusack

    Grasshopper

    Points: 19

    The whole process looks great!

    When I try to download the SQL procedures I get an empty screen saying that the search returned nothing.

    Can someone post a copy of the code39.sql in a reply?

    Thanks

    Anthony

  • yan_aung

    SSC-Addicted

    Points: 480

    Aa above, download still failed. Can some post it in reply?

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply