Post reply

Generating a Bar Code

  • February 3, 2005 at 2:10 pm

    #66875

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

  • February 8, 2005 at 7:22 am

    #541115

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

  • February 8, 2005 at 3:00 pm

    #541276

    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

  • August 2, 2005 at 5:46 am

    #578793

    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

  • August 26, 2005 at 11:51 am

    #585540

    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!

  • October 11, 2005 at 6:27 pm

    #596689

    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

  • April 7, 2006 at 3:04 am

    #631428

    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

  • November 13, 2006 at 5:09 pm

    #671472

    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>

     

  • January 14, 2008 at 10:45 pm

    #767977

    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

  • June 19, 2008 at 11:38 pm

    #831492

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

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

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