Need Suggestion: Control Print Duplication With 2 Pcs
Hi All,
Currently i have multiple PCs using the same BTW file to print EAN-13 template (query from MySQL db on latest running number) with a data entry form that prompt for quantity to print, once user enter number of quantity to print, it will then query from mySQL db the current running number + entry by user to re-update the value back into MySQL. (this is currently working fine)
My problem here is, if multiple PCs accessing the same BTW same time and since BarTender will first query from MySQL db on the latest running number for print preview / printing later before prompting the data entry (which user could possibly delay), then it is possible the duplicated EAN-13 numbers will be printed through the same printer.
Can you advice how i could avoid the duplication issue in this scenario?
I was thinking, is there anyway we could prompt the data entry form first before BarTender query from MySQL db?
Thank you.
-
Ok, guess i found the answer (after many trial and error). With BarTender v10.1 SR1 (currently installed), it does support OnPostPrompt event through named data source and select Type: Visual Basic Script and Script Type: Event Control Script but it does not allow template file object to be updated after the OnPostPrompt event with MySQL query (presumably i need the last saved EAN number from DB).
But on another test computer, i tried loaded up with BarTender 2016 (trial version) with the same source file, but it is ABLE to update template object after the OnPostPrompt, which makes me think could it be different versioning that was not addressed on SR1.
I then promptly updated our BarTender v10.1 from SR1 to SR4 (i had the registered 5 printers automation license), then simulate again the duplication problem. and it was able to update the template object during the OnPostPrompt event. Which then solve my duplication problem.
Thanks.
0
Please sign in to leave a comment.
Comments
1 comment