SQL, Barcode Readers, what to use for Scheduling production

[nwisp]

Hello, well here it is, we are useing an SQL DB
we track all of our customer Jobs' in this DB
I am useing Segate Crystal reports to provide reports,, for all the employees to access this DB we have a citrix application but it is limited on what we can do with it. the question I have is.
we would like to start using the BarCode for tracking and scheduling of Production a barcode is already being placed on all the Prodution Jobs'.. what would be a good software application for this, and keep in mind we need to be able to see and access this application fairly easy on a Network..
Or, is SQL all I need, and a good SQL programmer ?

I dont think Excel or Crystal Reports is what we are looking for.

Any Ideas would be greatly appreiciated.

[brian.mark]

What are you looking to do with a barcode scanner? We use them at our front counter and at our carousels for entering order numbers, entering products, and scanning locations for our carousels. That's all handled by software that worked exactly the same by hand keying stuff.

A barcode scanner is just another input device. Many go inline with the keyboard and just act like the keys were pressed. Even the USB versions do exactly the same thing (keyboards can be USB, so these work just like a USB keyboard that is a little faster at typing than you and I.)

Barcode is just a font. http://www.toolbarn.com/web-tools/barcode-code39/ will create a barcode from any text string you want. I have a simple Perl function that uses the barcode font to create a PNG graphic powering that page. The concept is pretty simple once you have the font.

Basically, the answer is you can use any program you want. As long as you have an input field that knows how to handle the data from the barcode and you have the font installed, you're fine.

Brian.

[nwisp]

I was able to use Segate Crystal Reports to provide some managers with a Visual for the Data they needed

all they have to do is scan the barcode on all the tickets they are going to look at for the day.

I did a {Sum is one of} type etry in crystal reports.
its not a cut and dry tpe of an application but it will work for now,

I wish I was a fairly good Programmer with SQL I would put this crap on an internal web server...

That is really what I need, I will keep my eye out for any such capable programmers...

Steven