0

I am trying to check if any child from Firebase Realtime Database matching data in sqlite database in my app with help of SQLiteAssetHelper. For this I wrote a function to check but it is returning NullPointerException error.

I have Check adding taskId in database manually, but still it is returning null value.

Error

ava.lang.NullPointerException: Attempt to invoke virtual method 'boolean mypackage.CompletedTasks.isComplete(java.lang.String)' on a null object reference

SQLiteAssetHelper Method

public boolean isComplete(String taskId) {
    SQLiteDatabase favDatabase = getReadableDatabase();
    String masterQuery = String.format("SELECT * FROM completedTasks 
    WHERE taskId = '%s'",
            taskId);
    Cursor cursor = favDatabase.rawQuery(masterQuery, null);
    if (cursor.getCount() <= 0) {
        cursor.close();
        return false;
    }
    cursor.close();
    return true;
}

Check in onBindViewHolder

if (completedTasks.isComplete(adapter.getRef(position).getKey())) {
        holder.taskCard.setVisibility(View.GONE);
} else {
        holder.taskCard.setVisibility(View.VISIBLE);
}
user5393041
  • 13
  • 5
  • From what you've shown, it looks like `completedTasks` is null. – Doug Stevenson Feb 17 '19 at 12:21
  • In my app there is list of task. and when user complete any task i want to save taskid in sqlite database. and then is recyclerview hide the task that are already completed by user by checking in sqlite db. – user5393041 Feb 17 '19 at 12:25

0 Answers0