Generating Label From Sql Database Follow

0
Avatar
Legacy Poster

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.

 

 

1 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

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

Please sign in to leave a comment.