[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 791
  • Last Modified:

Handheld scanner & code/software for MS SQL

Hello,

We need for our stock an handheld scanner which is capable communicating with MS SQL server somehow.

Stituation:
- a parcel is picked together, and being loaded on a truck
- when scanning a barcode, search for particular db-record, and change status to "shipped"

IF  scanned.pack_ID exists in tblpackage.pack_ID
THEN  change tblpackage.status to "shipped"
ELSE  do nothing "error, ID does not exist"

Have no industrial longrange wireless handheld scanner yet, thinking about buying:
- Datalogic Powerscan M8300, or Motorola/Symbol LS3578

Was first thinking about a handheld pda scanner with windows CE, like the Intermec CK31. But I think a wireless handheld scanner only is more bullet-proof?!? (anyway a lot cheaper)

What's the approach? All hints/directions are welcome...
0
joop123456
Asked:
joop123456
  • 3
  • 2
1 Solution
 
BarsMonsterCommented:
Well, you would need to write your custom application for that task, and that might cost a good peace of money :-)

It is possible to develop a program reading barcode and comunicating with MS SQL server via WiFi for example.
0
 
joop123456Author Commented:
What I'm actually looking for is everything but custom programming... Opensource or other software brands/packages?  I can not imagine that this not existing... data is probably for 95% kept in databases.....?!? So I need some names or a start-path...
0
 
BarsMonsterCommented:
0
 
joop123456Author Commented:
Fine, custom programming. I understand, but that's the last choice.

No opensource software somewhere or similar situations?
0
 
joop123456Author Commented:
moderator please delete this question..
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now