[android-developers] SQLiteDatabase.execSQL() not behaving as expected

2012-01-26 Thread Robert Hawkey
Hi everyone, I have an app I wrote for the iOS that makes extremely heavy use of a large database, I am now porting that app to the Android platform. I have a great deal of operations that follow this pattern: 1db.execSQL(CREATE TEMPORARY TABLE SearchResults(Name text);); 2

Re: [android-developers] SQLiteDatabase.execSQL() not behaving as expected

2012-01-26 Thread Mark Murphy
I have never used MATCH in SQLite. The LIKE operator uses %, not *, as the wildcard. http://sqlite.org/lang_expr.html On Tue, Jan 24, 2012 at 10:45 AM, Robert Hawkey rhaw...@gmail.com wrote: Hi everyone, I have an app I wrote for the iOS that makes extremely heavy use of a large database, I