Re: [sqlite] Causes of SQLITE_SCHEMA errors

2007-03-06 Thread Ian Frosst
Aha. I shall give it a try, and see how I fare. Many thanks, Ian On 3/6/07, Marco Bambini <[EMAIL PROTECTED]> wrote: Are you using sqlite_prepare or sqlite_prepare_v2? If you use the v2 version I think that your problem will be solved... Regards, --- Marco Bambini http://www.sqlabs.net

Re: [sqlite] Causes of SQLITE_SCHEMA errors

2007-03-06 Thread Marco Bambini
Are you using sqlite_prepare or sqlite_prepare_v2? If you use the v2 version I think that your problem will be solved... Regards, --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Mar 6, 2007, at 2:22 PM, Ian Frosst wrote: Hey all,

Re: [sqlite] Causes of SQLITE_SCHEMA errors

2007-03-06 Thread drh
"Ian Frosst" <[EMAIL PROTECTED]> wrote: > I have a periodic occurrence of SQLITE_SCHEMA > [A]re any strategies for avoiding this... > Use sqlite3_prepare_v2() instead of sqlite3_prepare(). -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] Causes of SQLITE_SCHEMA errors

2007-03-06 Thread Ian Frosst
Hey all, I've got a bit of an odd situation going on. I have a fairly heavily threaded app making use of SQLite (which is working beautifully for the most part.) However, I've run into a bit of a situation. It seems that I have a periodic occurrence of SQLITE_SCHEMA occurring when executing