Vbscripting Help

Legacy Poster

• 2016年03月02日 17:43

The information that is currently set to print on my label is being pulled from the database (Field: ShippingName). Sometimes that info is blank in the database and when it is, I need it to print from  (Field: TechnicalName).

 

Is there a way to do this with VBScript? Can someone please help me?

 

Thanks in advance.

0

• 

  Ian Cummings

  版主

  ★ BarTender Hero ★

  • 2016年03月03日 14:02

  Using an OnProcessData VB script for your database field data source, write something like the below:

   

  If value = "" Then

     value = Field("myDatabase.myTable.myField")

  End If

   

  You'll need to substitute in your own DB, table, and field names.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 2016年03月03日 21:23

  That worked almost perfectly. Bartender suggested using:

   

  ReferenceField("myDatabase.myTable.myField")

   

  At the beginning of the script and now it works perfectly.

   

  Thanks for the help as I do not know anything about scripting.

   

  :)

  0

请先登录再写评论。