Tuesday, April 10, 2012

Android sqlite get boolean from database


was just wondering, how can I obtain the value of a boolean field in a sqlite database in android?



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



Any takers?



Kev


Source: Tips4all
Post by On
Tags , , , ,

4 comments:

  1. UserApril 10, 2012 at 3:52 AM

    If memory serves me right:


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

    ReplyDelete
  2. UserApril 10, 2012 at 3:52 AM

    There is no bool data type in SQLITE. Use an int that you fix to 0 or 1 to achieve that effect. See the datatypes reference on SQLite3.

    ReplyDelete
  3. UserApril 10, 2012 at 3:52 AM

    You can also use
    boolean value =cursor.getString(boolean_column_index).contains("true");

    ReplyDelete
  4. UserApril 10, 2012 at 3:52 AM

    boolean value = (cursor.getInt(boolean_column_index) == 1);

    ReplyDelete

Subscribe to: Post Comments (Atom)