Re: [sqlite] querying with BLOB in WHERE clause, possible?

2014-11-15 Thread bjdodo
I've got it now. E.g. for delete you can do this: String sql = "DELETE FROM " + table + (!TextUtils.isEmpty(whereClause) ? " WHERE " + whereClause : ""); int argidx = 0; SQLiteStatement statement = mDB.compileStatement(sql); if (whereArgs != null)

Re: [sqlite] querying with BLOB in WHERE clause, possible?

2014-11-14 Thread bjdodo
Hi Sorry for resurrecting an old thread. I got the where clause working for queries with byte array arguments based on this discussion. I cannot find the way to use byte arrays in where clauses for update and delete statements. I know it is terrible to use byte arrays as query arguments, I need