Working with the SQLite-Database - Cursors

szeldon · Freshman Joined: 14 Feb 2008 Posts: 3

I'm not completly sure, but I think that you should close your cursor after using it.

nithin.warier · Developer Joined: 28 Feb 2008 Posts: 36

Hi plusminus,

how we can get the maximum value of an attribute in a table, in terminal , i checked and its working,

the query is -> select max(key) from Testing;

but how we can do this in Android.

please reply immediately

Thanks
Nithin

nithin.warier · Developer Joined: 28 Feb 2008 Posts: 36

Here, the return value is an integer, but for Sqlitedatabase.query() its returning cursor, so how can we get the integer value.

thanks
Nithin