Hi guys I am after some design help with a barcode project. I have a MS SQL server 2008 with a database that has a table with hundreds of EAN128 barcodes for products. I have connected Sick scanner and have succesfully scanned value into OPC tag in FSQL.
What I want to do is compare this with table of products and send either a 0 or 1 back to PLC to make a desicion on what direction to send carton. Also want to log all scanned cartons for end of shift and transfer back to 3rd party software that is connected to SQL.
Operator may need to sometimes select a barcode(carton) to go in other direction as well.
Can someone help with ideas on good design/principle on set up of this.