VBScript - Cannot add values?

Patryk Gawrysiak

• 2023年03月13日 09:21
• 編輯於

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 ★

  • 2023年03月13日 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 ★

  • 2023年03月13日 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

請登入寫評論。