Re-Query Database Each Time Serial Number Increments?
I'm competent with serialization/incrementing in Bartender. I also have substantial experience querying and pulling values from databases. Now, I'd like to re-query the database each time the serial number increments. Is there a way to do this?
Example:
- Operator enters first serial number in a range
- Operator enters quantity in range
- Bartender looks up the first serial number in the database and prints an associated test value to the first label
- Bartender increments the serial number (getting this far is no problem)
- Bartender looks up the next serial number in the database and prints its associated test value to the second label (this is what I need help with)
- repeat steps 4&5
I suppose if Bartender cannot go back and re-query the database with the printing of each label, maybe I could have it grab and temporarily store data for a large range of serial numbers at the beginning and then only make use of the quantity requested by the operator. This doesn't feel like a good solution though.
-
Hi,If your table already contains serial numbers and their associated test values, you may not need to manually enter serial numbers during the process.
You can configure the system to print directly via the database connection by selecting the desired serial numbers and specifying the quantity or copies for each through the Record Picker data entry control in the form. You could even include a pre-defined "quantity/copies" field in your database. This way, the form can auto-populate with the necessary copies, requiring updates only if adjustments are needed before printing.
0 -
Thank you! I'm testing this out and it looks like a good solution for what I'm trying to accomplish.
1 -
All the best! Hopefully it works
0
Please sign in to leave a comment.
Comments
3 comments