Hi, I read in the documentation for SQLite that there should be some core functions and aggregate functions available, but I can't seem to use them in my code.. Can anyone help?
Here's the documentation i read: http://www.sqlite.org/lang_aggfunc.html http://www.sqlite.org/lang_corefunc.html There is for example the function count() but how do I use it? I have tried to use it as stated below, but none of the functions in the documentation is available that way (i.e when I type "db." the list that shows in Eclipse documentation doesn't include any of the functions from the SQLite doc except from execSQL): ============================ import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.SQLException; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteException; import android.database.sqlite.SQLiteOpenHelper; import android.util.Log; public class DbAdapter{ ... private SQLiteDatabase db; ... public Cursor getRow(long rowId) throws SQLException { Cursor c = db.query(true, TABLE_NAME, new String[] { KEY_COL1, KEY_COL2}, KEY_ROWID + "=" + rowId, null, null, null, null, null); int numberOfRows = c.count(); //This doen't work! if (c != null) { c.moveToFirst(); } return c; } } ==================== Thankful for any help! PS. I haven't worked with databases before, so please keep that in mind when you answer me. DS. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
