Android SQLite Query and using cursor to deal with multiple rows

Question

Hi Guys,

I've got a query, (I'm using rawQuery())

  SELECT * FROM <table>

I'm then storing what it returns using a cursor. From their what I want to do is, start at the first row so.. cursor.moveToFirst() then take each column , column by column and store its particular value in a variable. I then want to move onto the next row and do the same. So I guess my question is How would I get cursor to deal with multiple columns?

Thanks,

Answer 1

What do you mean by "deal with" multiple columns? Will it be OK if you just drop the value from each column into distinct variables and then concatenate or otherwise munge them after parsing the database results?

Answer 2

I might be missing something here, wouldn't you have a nested loop.

The outer loop cycles through each records:

while (cursor.moveToNext()) {
  ...
  // inner loop here
  ...
}

and the inner loop would cycle through each column

for (i=0; i<cursor.getColumnCount; i++) {
  ...
  var1 = cursor.getString(i);
  ...
}