Handheld scanner & code/software for MS SQL
Posted on 2009-02-17
We need for our stock an handheld scanner which is capable communicating with MS SQL server somehow.
- 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...