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: pre 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