This document describes how to link a SQL table or a previous created SQL
view to BarTender (Designer), when using the E-WMS BarTender 'client' method.
When using SQL as data source, use a direct SQL
database (not ODBC) connection using a specific SQL user or 'Windows NT integrated security'.
In the first case, enable options 'Allowing saving password' and 'Save user name and password to format'.
Put the desired bar codes and texts on the
A BarTender query prompt field has to be used, so the label can be started for one specific transaction
ID. To create a query prompt field, follow these steps in BarTender:
Make sure the field 'Transactionguid' is available in the view
Choose BarTender menu File, Database Connection Setup
You will now see the Database Connection Setup screen, select the database name and then tab 'Query'
In BarTender 2016 this is called 'Filter':
Drop down the list box for 'Fields' and choose 'Transactionguid'
Choose Operator ' = ' (equals)
Drop down the list box for 'Criteria' and scroll down until you see 'New prompt ...'. Click on New prompt.
You will now see a dialogue screen to create a new 'query prompt'
(Bartender 8 and BarTender 2016):
change 'Name' to 'TransactionGUID'
attention: this name is case sensitive, please use this literal same name
Samples of the configuration in BarTender 8 and BarTender 2016:
Press OK in the Database Connection Setup screen and save the