Android Question null to zero vb equivalnet nz

[kris A]

what is the B4A equivalent of nz() for null to zero in vb?

 

[Erel]

Where does the null come from? Such a method is not required in most cases.

 

[kris A]

its from the geocoder library

 

[kris A]

nevertheless I think it is important to have nz function.

 

[Troberg]

I didn't even know VB had that, after working with it since 3.0 was released. I've used my own NullToZero and NullToEmptyString instead...

As soon as you work with databases, chances are that nulls will occur.

So, some null handling is quite useful to have.

 

[Troberg]

It's not that hard to make your own:

Sub NullToZero(Value as float) as float
  If Value = null Then
    Return 0
  Else
    Return Value
  End If
End Sub

...or something along those lines (can't syntax check it now).