IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Reports Topic   Print This     

Barcode only works with asterisk

Barcode only works with asterisk in Paradox Reports topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Barcode   asterisk   Barcode only   Barcode only works  
Peter Dissing
Aars DK

Hi

We want to bring our order-number as a barcode on paper. The number is an Integer in the field. For this we use a Code 39 font, and the barcode looks all right on paper, but can not be read by the scanner. Only if we change the field to Alpha and put in * as start and stop character it works. Any idea how to aviod the asterisk, and anyone who knows a font where it works 'out of the box' ? Can the setup for scanner be changed  ?

Using PDX11.

Best regards

Peter

 Posted 11 years ago (Thread Starter)
Comment Quote
About Peter Dissing -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13292, 4 replies
Thread Started 2/7/2009 9:33:36 AM
View Counter=27173
Last Reply Posted 2/10/2009 12:59:10 PM)
Location=Aars DK 
Joined=19 years ago   MB Posts=64  
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA

Barcode scanning relies on two factors, 1) clear contrast between the white and black and 2) clear definition of bar widths. As long as the font prints sharp images that produce clearly defined lines you should have little trouble with it. Your problem with *s has me stumped. I'll ask a few of my developers to see if they have an idea.

We've previously worked heavily with barcode systems and we used several freely available TTF font files with no problem whatsoever. We've had good results with their "code 39" symbology. I'll see if I can't dig up the name of one of the free ones for you.

--
Mike Prestwood
Prestwood IT Solutions

 Posted 11 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #13296 (Level 1.1)  Reply to 13292
Thread Started 2/9/2009 4:03:13 PM
Location=Prestwood IT office in Citrus Heights, CA 
Joined=20 years ago   MB Posts=1410   KB Posts=1805   KB Comments=69   BLOG, Topics=4  
Peter Dissing
Aars DK

Mike / Larry

Thanks for your comments. Have read the idautomation site, and testet the C39M font Version 3.07, without any luck. They have ActiveX Barcode controls for some different software, but not for Paradox. I tryed to install one of the .ocx files, but it worked badly and only in forms, and not reports. At the end it went into General Protection Error. We could change the values by using strings and put in the asterisks, but when we want to scan it again, it would corse problems.

Mike - I would be very interested to hear which font you have used.

Rgds Peter

 Posted 11 years ago (Thread Starter)
Comment Quote
About Peter Dissing -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #13298 (Level 1.2)  Reply to 13292
Reply Posted 2/10/2009 12:38:37 PM
Location=Aars DK 
Joined=19 years ago   MB Posts=64  
Larry Rutledge
-- USA

The reason for the asterisks has to do with the barcode type in use. They each have their own requirements including start/stop characters (asterisk) and alpha, or alpha-numeric, and/or symbols, etc.

The most common barcodes are UPC codes (the ones you see on products in stores) and I believe those are regulated; you have to get the barcode ID assigned to your product from a clearinghouse. The next most popular, the one I worked with the most, is Code 39 (also known as Code 3 of 9) ... here's a site with it's specs:

http://www.idautomation.com/code39faq.html

It has an asterisk start character, followed by the value to be represented by the barcode (can consist of 0-9, A-Z, space and several symbol characters) followed by a MOD43 check digit (explained in the URL above, and then a final asterisk stop character.

There are several hundred different types of barcodes, but UPC, Code 3 of 9 and Code 128 I believe are the most common ones.

It's been a long time since I worked with them, so I don't remember all the details. But hopefully that link will help you especially since you are working with Code 39 (Code 3 of 9). Let me know if you still have issues/questions and I'll see what I can dig up in my old files.


 Posted 11 years ago
Comment Quote
About Larry Rutledge -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Larry Rutledge

I worked for Prestwood Software as a Delphi developer from 1997 through 2002. During that time I enjoyed working with Mike Prestwood and the other developers at Prestwood.


Post ID #13297 (Level 1.3)  Reply to 13292
Reply Posted 2/9/2009 5:10:03 PM
Location=-- USA 
Joined=12 years ago   MB Posts=11   KB Comments=1  
Most Recent Post
Larry Rutledge
-- USA

Well, to produce a properly formed bar code, you have to follow the required specs (asterisks, etc). Most scanners/readers will detect the bar code type and only return the value (the number you actually wanted coded). So yes, you need to convert the output to string to produce the barcode.

If your bar code scanner/reader is passing the raw code data to you (including the asterisks, etc) then you will have to parse that out and get to just the value you want, but I'd be surprised if the scanner returned more than just the value of the barcode.

You should also make sure the barcode font you are using is in fact free (or you paid for it). If it's a demo font it may not produce all the characters as you expect. Here's one that is supposed to be free and work well (though I don't have a scanner handy so I've not personally tried it):

http://www.barcodesinc.com/free-barcode-font/

 Posted 11 years ago
Comment Quote
About Larry Rutledge -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Larry Rutledge

I worked for Prestwood Software as a Delphi developer from 1997 through 2002. During that time I enjoyed working with Mike Prestwood and the other developers at Prestwood.


Post ID #13300 (Level 1.4)  Reply to 13292
Reply Posted 2/10/2009 12:57:06 PM
Location=-- USA 
Joined=12 years ago   MB Posts=11   KB Comments=1  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P125A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #13292 Counter
27173
Since 2/7/2009
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]