Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Generating a Bar Code Expand / Collapse
Author
Message
Posted Thursday, February 3, 2005 2:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 24, 2007 4:33 AM
Points: 7, Visits: 3
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/mivica/generatingabarcode.asp


Post #159509
Posted Tuesday, February 8, 2005 7:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 6, 2005 11:15 PM
Points: 3, Visits: 1
all i can say is.... WOW!!!
Post #160251
Posted Tuesday, February 8, 2005 3:00 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 12:53 PM
Points: 469, Visits: 329

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
Post #160442
Posted Tuesday, August 2, 2005 5:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 11, 2005 6:38 PM
Points: 1, Visits: 1

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

Post #206427
Posted Friday, August 26, 2005 11:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 4:58 AM
Points: 13, Visits: 20

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!




Post #214529
Posted Tuesday, October 11, 2005 6:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 7, 2014 10:44 AM
Points: 1, Visits: 39

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

Post #228158
Posted Friday, April 7, 2006 3:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 31, 2008 3:36 AM
Points: 1, Visits: 7

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

Post #271835
Posted Monday, November 13, 2006 5:09 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 13, 2011 12:51 PM
Points: 55, Visits: 23

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>

 

Post #322458
Posted Monday, January 14, 2008 10:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, February 22, 2009 1:37 AM
Points: 1, Visits: 24
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
Post #442821
Posted Thursday, June 19, 2008 11:38 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 11, 2010 6:48 PM
Points: 48, Visits: 27
Aa above, download still failed. Can some post it in reply?


Post #520348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse