Generating Label From Sql Database

Legacy Poster

• October 14, 2015 11:52

I'm fairly new to VBscript and the inner workings of bartender, so please bear with me.

 

I've got a project where I would like to generate 6 different Label objects based on one user input and multiple SQL queries.

Basically, I'm attempting to remove the end user from making mistakes on the label by linking the program to our ERP system.

 

I'm sure this is possible, as I've already created a PHP program that shows the user exactly what the label should look like.

But I'd like to take this a step further, and have Bartender auto-fill the data requested.

However, My knowledge of VB and Bartender is nowhere near as extensive as my knowledge of PHP.

 

I've already created a Sub to connect to our ERP database, and that seems to work.

 

For starters, I'd like to know how to link a field from a Prompt Dialog to a VB variable,

and then Output Data generated from an SQL Query to Barcode string.

 

 

Thanks in advance.

 

 

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • October 16, 2015 10:16

  Let's start by making sure you understand what BarTender's database connectivity and query capabilities are.  See the below training videos to get you started.  If there is any lack, let me know what you need to do in addition.

   

  http://www.seagullscientific.com/label-software/training-video-(reading-data-from-database).aspx

   

  http://www.seagullscientific.com/label-software/training-video-(selecting-records-from-a-database-at-print-time).aspx

  0

Please sign in to leave a comment.