How to get null value from SQLite database in Android

Question

I am having trouble getting a null value from SQLite database using Android.

My database has 10 columns. From column 1 to 8 all are filled with values. But there are several rows where the values in column 9 and column 10 are either null or some number.

I want to check:

String selectQuery = "SELECT * FROM products WHERE barcodeId='" + id + "'";

Cursor myCursor = db.rawQuery(selectQuery, null);
if (myCursor.moveToFirst()) {

    //checking to see if there is something in column 9
    if(myCursor.getString(8) != null){
        // do soemthing
    }else {
        // if there is nothing do something
    }

    //checking to see if there is something in column 10
    if(myCursor.getString(9) != null){
        // do soemthing
    }else {
        // if there is nothing do something
    }
}

Can some one provide a working code according to my example with column 9 and 10 in my table.

A brief explanation will also be welcomed. Thanks

David C Adams · Accepted Answer · 2014-02-15 22:21:49Z

7

I don't know if Cursor.getString() will return a null or not. The docs don't say, it may just return an empty string. You should use Cursor.isNull() instead to check for a null value in your column.

answered Feb 15, 2014 at 22:21

David C Adams

1,97312 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:09:45Z

3

Thanks DavidCAdams that fixed my problem.

Here is my code if someone is interested in it.

if(myCursor.isNull(8)){
    Log.w("No value", "Cell is empty");
}else{
    Log.w("Value is present", "There is a value");
}   

if(myCursor.isNull(9)){
    Log.w("No value", "Cell is empty");
}else{
    Log.w("Value is present", "There is a value");
}

edited May 23, 2017 at 12:09

CommunityBot

11 silver badge

answered Feb 15, 2014 at 22:37

NewestUser

3,2505 gold badges24 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to get null value from SQLite database in Android

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related