Here's what I am trying to do:
1: scan a barcode in to a text field and using an SQL query look up the TIME column relating to that barcode & return the value in to a text box (this I can do no problem)
2: I then want to store that time in to a vision clientTag or something so that I can scan the next item
3: I then want another vision client tag or similar to take the value of the stored tag and the value of the new tag and add them together.
What I want to achieve is user can scan a stack of barcoded paperwork conseculativly and it will then display the total number of mins that have been scanned.
I toyed with the idea of having a SQL query that grows and adds each scan to the query to get the result but then hit walls as I'm not very good at this
My SQL table looks like this :
[ID]
,[DATE_TIME_STAMP]
,[CutTicket]
,[LayMins]
The values I am pulling are [CutTicket] - the barcode I scan as a string
[LayMins] the time allocated for each ticket.
How would you guys and gals go about having a vision client screen that enables the user to scan the barcode string and then creates a running total . (with maybe a clear button for when the running total is to be reset?)
Jon