Android Question Retrieving a Null Value

peggjones · May 11, 2015

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

Peter Simpson · May 11, 2015

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.

B4X:

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

eurojam · May 11, 2015

B4X:

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

incendio · May 11, 2015

Here is my version :

B4X:

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

Android Question Retrieving a Null Value

peggjones

Active Member

Peter Simpson

Expert

eurojam

Well-Known Member

incendio

Well-Known Member

Similar Threads

Android Question Retrieving a Null Value

peggjones

Active Member

Peter Simpson

Expert

eurojam

Well-Known Member

incendio

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency