How to get column value from sqlite cursor?

Question

I am trying to get column value from a cursor, this column is generated at run time by calculations inside the query, I am getting a null value of this column, I am able to get a value of all other columns which exists in SQLite table.

I execute the same query on SQLite editor, it also shows the value of generated column in result set.

Why this giving null value when I am retrieving it from cursor?

Please provide the code that you use to query and retrieve column values. — Mariusz Jamro, Feb 23 '12 at 11:26
@Chandrapal Yadav: are you sure,you are including that column when you fire query? be sure,you don't miss it! — Hiral Vadodaria, Feb 23 '12 at 11:37
try to look at this link.. using query method.. http://stackoverflow.com/questions/10600670/sqlitedatabase-query-method — Michimcchicken, Jul 26 '15 at 14:38

score 61 · Answer 1 · answered Feb 23 '12 at 11:29

61

Very Simple you can get it by either of following way

String id = cursor.getString( cursor.getColumnIndex("id") ); // id is column name in db

or

String id = cursor.getString( cursor.getColumnIndex(0)); // id is first column in db

answered Feb 23 '12 at 11:29

Lucifer

29,392
25
90
143

1

What is Cursor in this example? – Kala J Oct 30 '14 at 19:58
5

Second example should be `String id = cursor.getString(0);` – Luten Oct 05 '18 at 09:23

score 3 · Answer 2 · answered Jul 09 '12 at 12:43

3

Cursor column names are case sensitive, make sure you match the case specified in the db or column alias name

answered Jul 09 '12 at 12:43

Rafael Nobre

5,062
40
40

score 2 · Answer 3 · answered Oct 15 '15 at 11:40

If you don't know column index in select query the follow this,

Define constant for all fields of table so it is easy to get field name you don't need to verify its spell

create Database Costant class with name "DBConstant.java" and define table fields

public static final String ID = "id";

Then get value from cursor,

cursor.getString(cursor.getColumnIndex(DBConstant.ID));

cursor.getColumnIndex(field name); it returns field column index in you select statement cursor.getString(column index). it returns value which is on that column
If you know column index in your select query,

cursor.getString(0);

score 0 · Answer 4 · answered Mar 26 '19 at 07:13

If you want to get string value

String id = cursor.getString( cursor.getColumnIndex("name") ); // id is column name in db
or

String id = cursor.getString( cursor.getColumnIndex(0));

If you want to get Integer value

String id = cursor.getInt( cursor.getColumnIndex("id") ); // id is column name in db
or

String id = cursor.getInt( cursor.getColumnIndex(0));

Paulo Buchsbaum · Answer 5 · 2019-06-22T20:32:27.563

In Android Studio 3.4.1 (I use Kotlin but it does not make any difference here), I've discovered a very odd behaviour.

For instance:

Cursor c = db.rawQuery("Select IDH, ID, NOME, CONTEUDO from CalcHome 
           Inner Join Calcs using(id)", null)

The column names was registered in a rigid way, independent of case of field names in Select. The array component c.columnNames[0] is Idh not IDH

So

int a = c.getInt(c.getColumnIndex("IDH")) // gives a runtime error.

But

int a = c.getInt(c.getColumnIndex("Idh")) // works!

How to get column value from sqlite cursor?

5 Answers5

Linked