Generating a Bar Code

Author	Message
mivica	mivica Posted 12 years ago #159509
SSC Journeyman Group: General Forum Members Points: 83 Visits: 3	Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/mivica/generatingabarcode.asp 2
	Quote
gerardj	gerardj Posted 12 years ago #160251
Forum Newbie Group: General Forum Members Points: 7 Visits: 1	all i can say is.... WOW!!! 2
	Quote
Vasc	Vasc Posted 12 years ago #160442
SSCommitted Group: General Forum Members Points: 1817 Visits: 376	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 2
	Quote
owenzhang1977	owenzhang1977 Posted 12 years ago #206427
Forum Newbie Group: General Forum Members Points: 3 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 1
	Quote
ivica	ivica Posted 12 years ago #214529
SSC Veteran Group: General Forum Members Points: 205 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! 1
	Quote
Harold Espinosa Ch.	Harold Espinosa Ch. Posted 12 years ago #228158
Forum Newbie Group: General Forum Members Points: 5 Visits: 59	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 2
	Quote
Maria Iqbal Mir	Maria Iqbal Mir Posted 11 years ago #271835
Forum Newbie Group: General Forum Members Points: 3 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 1
	Quote
Matt Boiteau	Matt Boiteau Posted 11 years ago #322458
SSC Journeyman Group: General Forum Members Points: 95 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> 1
	Quote
anthony.cusack	anthony.cusack Posted 9 years ago #442821
Forum Newbie Group: General Forum Members Points: 5 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 2
	Quote
yan_aung	yan_aung Posted 9 years ago #520348
SSC-Enthusiastic Group: General Forum Members Points: 152 Visits: 27	Aa above, download still failed. Can some post it in reply? 2
	Quote

Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.

You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.