Re: [sqlite] Error : Library routine called out of sequence
I am facing one weird problem using SQLite. Many times I get an error Library routine called out of sequence while executing query Create table SOURCEFEED (SOURCEFEED,STATUS) values ( ABC,0) , I'm not getting the reason behind this. Why am I getting this error? My application is a multithread application and executes query from a worker thread. Are you trying to create a table or insert values into an existing table? I've never seen anything in SQL that suggests that you can do what you appear to be trying to do with that query, i.e. insert rows into a table while creating it.
Re: [sqlite] Error : Library routine called out of sequence
On Jun 28, 2005, at 5:08 AM, Ajay wrote: I am trying to insert values into table and executing that query from thread. There are 2 more threads that accesses same table. Do all the threads use the same sqlite handle? I believe that can cause problems.
RE: [sqlite] Error : Library routine called out of sequence
Yaa You are right; I solved the problem by using some of synchronization objects for thread access. Thanks for giving me direction. -Original Message- From: Will Leshner [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 28, 2005 7:07 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Error : Library routine called out of sequence On Jun 28, 2005, at 5:08 AM, Ajay wrote: I am trying to insert values into table and executing that query from thread. There are 2 more threads that accesses same table. Do all the threads use the same sqlite handle? I believe that can cause problems.