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

2012-01-27 Thread Robert Hawkey
: fts4SQL error: near sqlite: syntax error sqlite On Jan 26, 3:15 pm, Robert Hawkey rhaw...@gmail.com wrote: SQlite supports FTS3 and FTS4 (full text searching).  I've seen documentation (don't have it handy) that FTS3 is enabled in the build of SQLite shipped in the API level I'm using so

[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

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

2012-01-26 Thread Robert Hawkey
via rawQueries I get the full results. Rob On Jan 26, 2:23 pm, Mark Murphy mmur...@commonsware.com wrote: 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