[android-developers] Re: How to query the number of rows in a table

2009-05-04 Thread Marco Nelissen
select count(*) from table See also http://sqlite.org/lang.html On Mon, May 4, 2009 at 9:51 AM, Lucius Fox lucius.fo...@gmail.com wrote: Hi, Can you please tell me how to query the number of rows in a table in Android? Assume I have the name of the table in string. Thank you.

[android-developers] Re: How to query the number of rows in a table

2009-05-04 Thread Lucius Fox
On Mon, May 4, 2009 at 9:58 AM, Marco Nelissen marc...@android.com wrote: select count(*) from table See also http://sqlite.org/lang.html Thank you. Here is what i try: public void getRow(SQLiteDatabase db) { db.beginTransaction(); try {

[android-developers] Re: How to query the number of rows in a table

2009-05-04 Thread Marco Nelissen
On Mon, May 4, 2009 at 1:17 PM, Lucius Fox lucius.fo...@gmail.com wrote: On Mon, May 4, 2009 at 9:58 AM, Marco Nelissen marc...@android.com wrote: select count(*) from table See also http://sqlite.org/lang.html Thank you. Here is what i try: public void getRow(SQLiteDatabase db) {