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,
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++) {
...
String var1 = cursor.getString(i);
...
}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With