Re: [sqlite] Some SQL statements are not executing

2009-07-20 Thread Gary Verhaegen
On 20 Jul 2009, at 17:29, Simon Davies wrote: > As indicated inline, you are not handling error returns from sqlite3_step() > > This may not be the whole story, but ensure that you are not getting > an error returned. > > Regards, > Simon On 20 Jul 2009, at 17:26, Pavel Ivanov wrote: > Sounds

Re: [sqlite] Some SQL statements are not executing

2009-07-20 Thread Simon Davies
2009/7/20 Gary Verhaegen : > Hi everybody, . . . > I have narrowed the problem to the few following lines : > > > #define DEBUG > > int db_execute(sqlite3 *db, char stmt[STR_LEN]) { > DEBUG   PRINT("\nentering db_execute with statement %s.", stmt); >       int ret=0; >  

Re: [sqlite] Some SQL statements are not executing

2009-07-20 Thread Pavel Ivanov
Sounds like you're running several instances of your application in several different processes simultaneously on the same database. Are you sure you don't do that? Pavel On Mon, Jul 20, 2009 at 11:08 AM, Gary Verhaegen wrote: > Hi everybody, > > I just subscribed and

[sqlite] Some SQL statements are not executing

2009-07-20 Thread Gary Verhaegen
Hi everybody, I just subscribed and this is my first post - I hope I am not making any deadly mistake by posting about a problem I have with SQLite. As the title suggests, I have some trouble with SQL statements randomly not executing. Here are the details. First, the machine. It is running a