The native SQLite code bundled with System.Data.SQLite is not compiled
with the SQLITE_ENABLE_FTS3_PARENTHESIS option, which is required for
the expression you are asking about to work properly.
Of course, it can always be recompiled if you have access to Visual C++,
by editing one of the following files and recompiling the SQLite.Interop
project:
<root>/SQLite.Interop/props/sqlite3.vsprops (for VC++ 2008)
<root>/SQLite.Interop/props/sqlite3.props (for VC++ 2010)
Where <root> is the root of the source tree for System.Data.SQLite.
--
Joe Mistachkin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
