B4J Question Unpredictable Null Point Exception

[krzyszp]

Hello,

I have silly problem...
I have created query to database and sometimes one or more fields return "NULL" and I get exception for this...
How I can catch nulls in recordset and go to next command without stopping app?

 

[Erel]

Can you post the code that fails?

 

[krzyszp]

lblJobRef.text = m.Get("JobRef")

In this case record "JobRef" returns NULL (sometimes, sometimes not - depend of number of factors).

 

[Erel]

You can use the ifnull command to convert the null value to an empty string (or to any other value):

"SELECT ifnull(JobRef, ''), ... FROM ..."