Generating a Bar Code

Question

Post reply

Generating a Bar Code

mivica

SSC Enthusiast

Points: 155
More actions
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

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

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

gerardj SSC Rookie Points: 43 More actions · Answer 1

gerardj

SSC Rookie

Points: 43

February 8, 2005 at 7:22 am

#541115

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

Vasc SSCarpal Tunnel Points: 4643 More actions · Answer 2

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 More actions · Answer 3

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 More actions · Answer 4

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 More actions · Answer 5

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 More actions · Answer 6

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 More actions · Answer 7

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..

<!-- @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>

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

anthony.cusack Grasshopper Points: 19 More actions · Answer 8

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 More actions · Answer 9

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

Generating a Bar Code

Cookies on SQLServerCentral