Android Question Retrieving a Null Value

How can I ignore a null value?

When I execute code like the following

Log(Cursor.GetString("number"))

If number contains a null I would like to just ignore it rather than have the program fall over.

Is there any an easy way to do this?

Many Thanks

 

Have you tried placing your code within the Try statement? Personally I would try the code below. If that does not work then just change your SQL query to replace Null with a 0.

Just a quick guess as I'm typing using my phone.

Code:

Try
     Number = Cursor.GetString("number")
Catch
     Log(LastException.Message)
     Return
End Try

 

Code:

If Cursor1.GetString("number") <> Null Then
  myNumber = Cursor1.GetString("number")
Else
  myNumber= "NULL"    'or whatever
End If

you can also use Cursor1.GetDouble to retrieve numbers

 

Here is my version :

Code:

Lbl.Text = GetString(1)
If(Lbl.Text = "null") Then Lbl.Text = ""