Vb Scripting And Sql Data 追蹤
Bartender V10 SR $ moving to 10.1 in a few weeks if that makes a difference.
I have very little experience with VB scripting … in fact I have only created two labels using VB scrip transform and they used simple If …else statements to determine the value of a field.
What I would like to do here is more complicated than that and I can’t find anything in the VB script editor in Bartender to assist me here, nor have I found anything on the forums. I would like to know if the following is possible and maybe some information to get me started.
I have a label document that contains a SQL database connection with multiple tables and a query prompt for the production order number. Of these tables one field has the possibility of containing a field value similar to <<Item Number = 808>> where 808 is the customer number. We currently have a program that converts this data into the value in another table (we are not using bartender to print these labels currently). I would like to expand the if … else statement so that if this value is found It searches the table (which currently does not exist in the database setup) for the dynamic value of our item number and the
customers number (based upon the returned data of the query prompt) to return a value for the customers item number.
Is this possible? I tried to do this using the query builder in the database connection but I could never figure out how to make a variable dynamic based upon the query used in the document.