Using A Share/name Field As The Query For A Sql Statement Follow

Legacy Poster

I am trying to modify an existing label which our WMS system has. I am trying to add an additional field based on what's already been created in the label. The label has Pick Ticket Number as a share/name field that get's passed in by the WMS system and I would like to use that as a query to a SQL DB to add additional fields that I need. 

I can't seem to form my query correctly. I tried doing a VB Script on the label options that says OnPrintJobStart Format.NamedSubStrings("PICKTICKETNO").Value = PTnum and then tried to use the PTNum as my query but that's not working. 


Any help would be greatly appreciated. 

Please sign in to leave a comment.