Hi All,
I'm using the latest System.Data.SQlite downloaded from the website.
When I query a FTS3 table (called FreeText) using the code below I get
the following warning in the VS output window.
SQLite error (1): no such table: main.FreeText_stat
>From reading the docs I believe FreeText_stat is created if I'm using
FTS4 which I'm not as it is not enabled in the .Net Wrapper.
Am I safe to ignore this warning? The code seems to function fine.
using (SQLiteConnection conn =
DBUtilities.OpenConnection(Path.Combine(dataFolder,
DocFetchConst.DocDataName)))
{
using (SQLiteCommand command = conn.CreateCommand())
{
command.CommandText = "SELECT f.Content FROM FreeText f,
FreeTextData fd WHERE f.rowid = fd.FreeTextId AND fd.DocumentVersionId
= @DocumentVersionId AND fd.Page = @Page";
command.Parameters.Add(new
SQLiteParameter("@DocumentVersionId", docVerData.DocumentVersionId));
command.Parameters.Add(new SQLiteParameter("@Page", page));
return DBUtilities.GetValue<string>(command.ExecuteScalar(), "");
}
}
Thanks,
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
