How to return query result in android sqlite database?

Question

I'm new in android developer ,I'm a programmer Delphi and Lazarus, I have a program using SQLite Database and I'm trying to get the same program in android, but I have many questions.

I need a method to return an result of an select like:

SELECT * from tmc_configuracao ORDER BY cod_configuracao DESC

After that i will send this result to a scrollingtable" I have no idea how to do this.

Anyone can help me with the code?

Raptor · Accepted Answer · 2014-01-09 04:31:59Z

6

String query="SELECT * from tmc_configuracao ORDER BY cod_configuracao DESC";
Cursor cursor=(instance of SQLiteDatabase).rawQuery(query);
while (cursor.moveToNext()) {
  String result_0=cursor.getString(0);
  String result_1=cursor.getString(1);
  //and so on
}
cursor.close();
(instance of SQLiteDatabase).close();

edited Jan 9, 2014 at 4:31

Raptor

54.4k47 gold badges254 silver badges405 bronze badges

answered Dec 7, 2011 at 17:09

Its not blank

3,11524 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Raptor Over a year ago

rawQuery() takes at least 2 parameters: developer.android.com/reference/android/database/sqlite/…

androidtitan Over a year ago

You can replace the second parameter with null if you do not want to have any selectionArgs. Cursor testCursor = sqLiteDatabase.rawQuery(sqlQuery, null);

Collectives™ on Stack Overflow

How to return query result in android sqlite database?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related