Android Question How to read a null value from db?

[amorosik]

It often happens to read lines from a db where some fields are null
Attempting to add a row to a FlexGrid when a field is null invalidates the entire row insert operation
The question is: how to read db fields whose content is null without creating problems for subsequent instructions?
Is the only way the classic comparison via IF or are there any tricks to protect the reading of db fields and prevent a Null from being returned?

 

[Andrew (Digitwell)]

One option is to define the database with default values so that the returns are never null.

 

[amorosik]

One option is to define the database with default values so that the returns are never null.

Yes, of course
But in some cases the db is not under your diret control, and you have to read 'other peoples data'
In this case you have no control over what is entered, it is only possible to protect the db read

 

[LucaMs]

Use the IfNull (sql) function (search for it ? )

 

[brent judith]

use IS NULL or IS NOT NULL instead of comparison operator.