VBScript - Cannot add values?

Patryk Gawrysiak

• 13 de marzo de 2023 09:21
• Editado

Hi Guys, I am attempting to add two values together just like this:

However, instead of these values adding together, they are concatenating.. I am unsure as to why, as I double checked the VBScript 'Addition' uses '+' and the Concatenation uses '&'..

Here is the process:

End Result:

 

I would expect 548  (1 + 547).

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 13 de marzo de 2023 09:53

  Although the values are numeric the VB is thinking they are text and so is concatenating the fields together. If you add CInt(......) to both strings then that will then work

  ie Value = CInt(Format.NamedSubStrings("TotalOrder").Value) + CInt(Field....<etc>....)

  0
• 

  Patryk Gawrysiak

  ★ BarTender Hero ★

  • 13 de marzo de 2023 10:01

  Thanks Peter Thane, 

  I used your method and ran into an overflow error, however I fixed it by using 'CLng' instead of 'CInt'

  Thanks Again.

  0

Iniciar sesión para dejar un comentario.