Re: [sqlite] Exception when querying a range index

2014-03-12 Thread St. B.
Ok, I have updated my database with analyze so that stat1 and stat4 tables have been created. I also have added an index to a table, in order to get rid a an auto index warning after each query. It seems that now out of some "Database locked" errors, I am not getting the original error message any

Re: [sqlite] Exception when querying a range index

2014-03-11 Thread Simon Slavin
On 11 Mar 2014, at 10:59pm, St. B. wrote: > So I updated to V1.0.91 of SDS, but now I get the following error at each > query run against the database : > SQLite error (1): no such table: sqlite_stat1 > > What should I do to get the table properly created? Open the database and execute the SQL

Re: [sqlite] Exception when querying a range index

2014-03-11 Thread Richard Hipp
On Tue, Mar 11, 2014 at 6:59 PM, St. B. wrote: > HI, > > So I updated to V1.0.91 of SDS, but now I get the following error at each > query run against the database : > SQLite error (1): no such table: sqlite_stat1 > What is the text of the query you are running? > > What should I do to get the

Re: [sqlite] Exception when querying a range index

2014-03-11 Thread St. B.
HI, So I updated to V1.0.91 of SDS, but now I get the following error at each query run against the database : SQLite error (1): no such table: sqlite_stat1 What should I do to get the table properly created? On Tue, Mar 11, 2014 at 12:50 PM, Simon Slavin wrote: > > On 11 Mar 2014, at 11:06

Re: [sqlite] Exception when querying a range index

2014-03-11 Thread Simon Slavin
On 11 Mar 2014, at 11:06am, St. B. wrote: > There is one writing thread (every 5 minutes). The one writing thread > writes in the same database, but it is on a different table. Have you set a timeout for all your database handles (or just the one handle if they're all using the same handle):

[sqlite] Exception when querying a range index

2013-01-06 Thread St. B.
Hi All, I have an application using sqlite to store coast lines (application runs on windows and uses the .Net version of sqlite v1.0.83). I use range indexes to look-up coast line within range of a given point. During run time I find that the following exception occurs. vtable constructor faile