Using A Share/name Field As The Query For A Sql Statement Follow
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.