So I finally got it work. For the ones interested the working code is below: private int getItemViewType(Cursor cursor) { String type = cursor.getString(cursor.getColumnIndex(“type”)); if (type.equals(“1”)) { return 0; } else { return 1; } } @Override public int getItemViewType(int position) { Cursor cursor = (Cursor) getItem(position); return getItemViewType(cursor); } @Override public int getViewTypeCount() { … Read more
ORMLite now supports next(), previous(), moveRelative(offset), … methods on the CloseableIterator class. This should allow you to move the underlying Cursor object around at will. It also supports the following DAO Cursor methods: dao.mapSelectStarRow(databaseResults) Return the latest row from the database results from a query to select *. With this you can change the cursor … Read more
Your database doesn’t have to have a column called ‘_id’ but the SimpleCursorAdaptor does need to have one returned. You can do this with an alias. An example is that I have a table with columns… uid,name,number To query this for a SimpleCursorAdapter, I do this with a database rawQuery… SELECT uid as _id,name,number FROM … Read more
Really simple example. Here is a really simple, but very effective, example. Once you have the basics down you can easily build off of it. There are two main parts to using a Cursor Adapter with SQLite: Create a proper Cursor from the Database. Create a custom Cursor Adapter that takes the Cursor data from … Read more