File Integration with Link to SQL Database

Thomas Kischke

• October 08, 2021 21:34

I have a set of fields in a trigger file as part of a file integration.  The value of these fields is printed on a label.  I now want to add another field to this label which is not part of the trigger file.  Instead it needs to be pulled from a table in a SQL Server database.  Is this possible?  I tried to join the integration file with the database in the database connection area but it does not work.  Maybe I'm doing something else wrong.  Any help would be appreciated.

0

• 

  pthane

  ★ BarTender Hero ★

  • October 11, 2021 07:41

  I believe the procedure would need t o be something like this, Join the two files together in the label and then create the filter to carry out the SQL look up. The filter value would need to the new field you are adding to the end of your trigger file.

  You would need to refrsh the connection to the label in the integration to pick up the changes in the label template

  0

Please sign in to leave a comment.