Connect To Db Only On Time Per Print Job 关注
Edition: Enterprise Automation, Version: 9.4 SR3
The attached screen shot shows a text field that uses VB script as the datasource. The script connects to an Access database to retrieve data that is not in the text file database. The script works fine, but print speed has slowed tremendously. Before this field was added, the labels printed continuously, without pausing between labels. Now, there is a one to two second pause between each label.
My guess is that bartender must connect/disconnect from the db for each label that prints, causing the slow print speed. If so, is there a way to have bartender connect to the db at the start of the print job and keep it open until the job has ended?
I tried to connect to the db in the "OnPrintJobStart" event and then update and read the recordset using vb script in the datasource of the text file, but that did not work.
Michael Toupin (mtoupin