<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 General Discussion
»
Barcode 128 generator (using scalar function)...
Barcode 128 generator (using scalar function)
Rate Topic
Display Mode
Topic Options
Author
Message
a_ud
a_ud
Posted Thursday, February 17, 2011 4:47 AM
Valued Member
Group: General Forum Members
Last Login: 2 days ago @ 2:12 AM
Points: 67,
Visits: 269
I'm looking for a barcode generating Function that uses the standard Code128. Apparently no function that fixes this has been posted before in the forum.
The way the barcode functions work is always the same: you pass a string with the source code ('bananas') and you get the coded barcode string ( ÑbananasÈÓ, always starts with capital Ñ and ends with Ó).
I have the right function in Access VBA (code attached), but I'm not able to translate this into SQL Server.
Does anyone have the equivalent SQL Server function (or knows how to translate this) ?
Thanks in advance, a.
Post Attachments
basCode128.txt
(
71 views,
3.77 KB
)
Post #1065554
andrewfyl2
andrewfyl2
Posted Tuesday, October 23, 2012 2:19 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, December 04, 2012 3:10 AM
Points: 3,
Visits: 7
please check out the
Code128 barcode generation library for SQL Server
.
Post #1375891
Kirk_Brown_1986
Kirk_Brown_1986
Posted Sunday, January 20, 2013 7:48 PM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, January 20, 2013 7:43 PM
Points: 1,
Visits: 0
I am using this
SQL Server Reporting Service Barcode Generator
. It's good and you can adjust the parameters of QR Code easily. I suggest you have a try. You can also find many other barcode generators on the site, such as
Java QR Code barcode generator with detailed guide
. Hope it's helpful.
Post #1409336
earlmason986
earlmason986
Posted Sunday, January 27, 2013 7:57 PM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, January 27, 2013 7:55 PM
Points: 1,
Visits: 0
You can test this
code 128 generator
.Hope this fits your needs.
Post #1412165
tarcode_winforms
tarcode_winforms
Posted Wednesday, January 30, 2013 9:13 PM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, February 03, 2013 6:58 PM
Points: 3,
Visits: 6
To encode data string in Code 128, you may find a code 128 font or barcode control supports Code 128 generating in .NET app. I guess the
SSRS CODE 128
control is OK.
Post #1413835
aframiller326
aframiller326
Posted Tuesday, March 26, 2013 9:57 PM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, June 05, 2013 9:42 PM
Points: 2,
Visits: 5
Sorry, can you tell me what is the purpose of
generating
such a
Code 128 barcode
? I have no idea what you are trying to achieve. By the way, I know a website that has many conversion tools for class code. Hope it works.
http://www.developerfusion.com/tools/convert/
Post #1435756
Ewan Hampson
Ewan Hampson
Posted Monday, April 08, 2013 4:20 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, June 10, 2013 2:36 AM
Points: 140,
Visits: 1,537
The way the barcode functions work is always the same: you pass a string with the source code ('bananas') and you get the coded barcode string ( ÑbananasÈÓ, always starts with capital Ñ and ends with Ó).
I expect one or more of the functions/tools people have suggested will do the business.
But I wanted to point out that Code 128 is not quite like that. Unlike eg Code 39, it is not a straight character-for-character substitution, so just applying a font with static bracketing values doesn't work. It needs a calculated checksum (which is not shown in the human-readable version nor transmitted to the receiving system, but ensures the quality of the data read by the scanner), which is why you need to apply a function to the data you want to encode. And I do not think the control characters are universal - I have seen different font sets that have made different choices with regard to the extended characters they use to represent the control values. Presumably the ones you specify will work for your environment.
Post #1439735
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
