Get boolean from database using Android and SQLite

java android sqlite boolean
Kevin Bradshaw picture Kevin Bradshaw · Nov 3, 2010 · Viewed 82.6k times · Source

How can I obtain the value of a boolean field in an SQLite database on Android?

I usually use getString(), getInt(), etc. to get the values of my fields, but there does not seem to be a getBoolean() method.

Answer

Alex Orlov picture Alex Orlov · Nov 3, 2010

It is:

boolean value = cursor.getInt(boolean_column_index) > 0;

Related questions

SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I've read and tried, you can just use the: execSQL(String sql) method or the: …

Read More
How to use an existing database with an Android application

I have already created an SQLite database. I want to use this database file with my Android project. I want to bundle this database with my application. Instead of creating a new database, how can the application gain access to …

Read More
UNIQUE constraint failed: sqlite database : android

I am trying to insert values in table. But there is only one value inserted. I am getting an error in log cat when I am trying to insert new values. Log cat shows : abort at 13 in [INSERT INTO event(…

Read More