Writing Back To Web Database To Update A Vlue フォローする
Hello! I have an application in Bartender that selects all records that need to be printed based on a field winch by default is zero. The records are inputted from multiple locations to create and track cars with a parking sticker.
Currently, I have been executing a script in a web page that updates the 0 to 1's so they do not get printed a second time. The database is MySQL and the ODBC connection works fine and the SQL script in bartender selects only the records that need to be printed.
I would like to write back to the database field after a print session to automatically update the records to a printed status.
Can this be done with the VB Scripting? If so advice is welcome. I have created a VB script in Excel that updates a database, but I have been unsuccessful in trying to create an auto update after print within bartender. I am using Bartender 2016 Enterprise Automation.
Any help will be greatly appreciated. Thanks!