Hi,
I created SQLite base with 3 tables and custom ContentProvider. I had
a crash on first call method query.
I tried to get cursor from base via db.query(table, columns,...) it
worked correctly.
The exception is android.database.sqlite.SQLiteException: no such
column: modified: , while compiling: SELECT items._id, items.name FROM
items ORDER BY modified ASC
Whats wrong?
The method is below:
@Override
public Cursor query(Uri url, String[] projection, String selection,
String[] selectionArgs, String sort) {
SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
String tableName = getTableName(url);
final int uri = urlMatcher.match(url);
qb.setTables(tableName);
String defaultOrderBy = null;
if (isCollectionUri(url)) {
switch (uri) {
case ITEMS_URI_CODE:
qb.setProjectionMap(itemsMap);
defaultOrderBy = Items.DEFAULT_SORT_ORDER;
break;
case LISTS_URI_CODE:
qb.setProjectionMap(listsMap);
defaultOrderBy = Lists.DEFAULT_SORT_ORDER;
break;
case CELLS_URI_CODE:
qb.setProjectionMap(cellsMap);
defaultOrderBy = Cells.DEFAULT_SORT_ORDER;
break;
default:
throw new IllegalArgumentException("Unknown URL
" + url);
}
}
else {
qb.appendWhere("_id=" + url.getPathSegments().get(1));
}
String orderBy;
if (TextUtils.isEmpty(sort)) {
orderBy = defaultOrderBy;
} else {
orderBy = sort;
}
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
// this method throw sqliteexception: no such column:
modified....
Cursor c = qb.query(db, projection, selection, selectionArgs,
null,
null, orderBy);
c.setNotificationUri(getContext().getContentResolver(), url);
return c;
}
The Log is 08-13 11:49:59.471: ERROR/AndroidRuntime(5237): Caused by:
android.database.sqlite.SQLiteException: no such column: modified: ,
while compiling: SELECT items._id, items.name FROM items ORDER BY
modified ASC
--
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
