Updating An External Db (Not Set Up Under Db Connections) Follow
Using BarTender 10, I have 3 databases, 2 of which I can include in the label as they have a relationship; however the third I cannot. I need to pull and update information from the third DB and have resorted to using VBScript. I have it working, but there are some issues. The issue is the database is being updated several times or is updated even if the event isn't triggered. In an attempt to simplify troubleshooting, I have created a blank label with a single line text object on it. This object should display the data value and when printing is completed, update the DB value by 1 (serialization). To get the value to display I used VBScript found under the Text Properties > Transforms tab then under VBScript "Using VB Scripting" > OnProcessData. I had the update DB code in here originally but it would update 13 times when run, so I moved the update DB portion to Text Properties > Data Source > Event Controls Scripts (Edit with Scripting Assistant) > OnPrintEnd.
The issue I am noticing is, when going in to the properties of the text object, and viewing the OnPrintEnd, if you click on OK after, it appears to execute the update. Is there a reason for this?
Also, if I have done something wrong or if there is a better way of going about what I and trying to achieve, please let me know. Your help/insight is appreciated!
See attached sample (download and rename to ZIP), extracting the files and structure to your C drive.
Please sign in to leave a comment.