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

select count(*) from table See also http://sqlite.org/lang.html On Mon, May 4, 2009 at 9:51 AM, Lucius Fox 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

On Mon, May 4, 2009 at 9:58 AM, Marco Nelissen 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 { db.execSQL("select count(*) from

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

On Mon, May 4, 2009 at 1:17 PM, Lucius Fox wrote: > > On Mon, May 4, 2009 at 9:58 AM, Marco Nelissen > 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(); >