Default value for empty database field

Ivan Burden

• April 11, 2023 13:04

Hello Community,

We are currently use SQL for our database fields in a few of our labels. If the database field we are pulling has an empty value, can we default a value to be inserted in its place?

We are finding that with specific labels if that value is blank, it leaves off the barcode.

Thank you

 

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • April 11, 2023 15:49

  You could make the field a VB script routine with an If...Then...Else statement. Something like (this is not the right VB code)

  If <Database field> = "" then

  Value = "Hello"

  Else Value = <Database field.Value>

  0

Please sign in to leave a comment.