SQLite problem

waideman · by **waideman** » Wed May 06, 2009 2:33 pm

Hi all!

I'm a newbie in Android and i'm studying/doing some apps using sqlite. I need build a method that returns the following query

select max(rowid) from DB_TABLE

i did this method, but it doesnt log anything and doesn't return any value. the database opens, creates and insert data in the table normally. somebody can help me???

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

 
        public int getMaxRowID(){
 
                int x = 0;
 
                Cursor result = mDB.query(true, DB_TABLE, new String[]{"max(rowid)"}, null, null, null, null, null, null);
 
                Log.i(TAG, "X = " + x+1 + "fudeu");
 
                return result.getInt(x);
 
        }
 
}
Parsed in 0.031 seconds,  using GeSHi 1.0.8.4

nmc · by **nmc** » Wed May 06, 2009 4:31 pm

Do you have a column named 'rowid' in your table?
In my projects, I always use db.rawQuery(sql, null); with 'sql' being a fully specified sql-statement;
with this, a db.rawQuery("select max(id) from mytable", null) works just fine.

waideman · by **waideman** » Wed May 06, 2009 5:10 pm

nmc wrote:Do you have a column named 'rowid' in your table?
In my projects, I always use db.rawQuery(sql, null); with 'sql' being a fully specified sql-statement;
with this, a db.rawQuery("select max(id) from mytable", null) works just fine.

wow, thanks!!
i'll try using rawQuery instead of just query.. =D

SQLite problem

SQLite problem

Who is online