Using A Share/name Field As The Query For A Sql Statement S’abonner

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. 

Vous devez vous connecter pour laisser un commentaire.