Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-25 Thread Jean-Denis Muys
On 2/24/10 19:12 , Mike Shal mar...@gmail.com wrote: On 2/24/10, Jean-Denis Muys jdm...@kleegroup.com wrote: On 2/24/10 9:36 , Simon Davies simon.james.dav...@googlemail.com wrote: Rogue semicolon on line if( sqlite3_close( db ) != SQLITE_OK ); Regards, Simon I have been

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-25 Thread Jean-Denis Muys
On 2/24/10 19:19 , D. Richard Hipp d...@hwaci.com wrote: On Feb 24, 2010, at 1:12 PM, Mike Shal wrote: This compiler is llvm. Check it out at http://llvm.org You can test for this mistake on the demo page at http://llvm.org/ demo FWIW, there are currently two places in SQLite

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-24 Thread Simon Davies
On 23 February 2010 17:44, newlog newlog2...@yahoo.fr wrote: OK, With the following code : - sqlite3        *db = NULL;  if( sqlite3_open( D:\Test3.db, db) != SQLITE_OK )       {        // Exit if error while opening.        wxMessageBox(

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-24 Thread Jean-Denis Muys
On 2/24/10 9:36 , Simon Davies simon.james.dav...@googlemail.com wrote: On 23 February 2010 17:44, newlog newlog2...@yahoo.fr wrote: OK, I really don't understand Rogue semicolon on line  if( sqlite3_close( db ) != SQLITE_OK ); Regards, Simon I have been bitten by such

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-24 Thread newlog
I CAN'T BELIEVE I'VE DONE THIS !!! I must be so stupid that I've spent days wondering why. Thank you so much Simon for your very advised look on my code. I deeply apologize for polluting that forum with such a silly mistake. Regards Very well done Simon !! On Feb 24, 9:54 am, Jean-Denis

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-24 Thread Mike Shal
On 2/24/10, Jean-Denis Muys jdm...@kleegroup.com wrote: On 2/24/10 9:36 , Simon Davies simon.james.dav...@googlemail.com wrote: Rogue semicolon on line if( sqlite3_close( db ) != SQLITE_OK ); Regards, Simon I have been bitten by such silly mistakes often enough! This

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-24 Thread D. Richard Hipp
On Feb 24, 2010, at 1:12 PM, Mike Shal wrote: This compiler is llvm. Check it out at http://llvm.org You can test for this mistake on the demo page at http://llvm.org/ demo FWIW, there are currently two places in SQLite where we have had to complicate the code in order to work around

[sqlite] sqlite3_close == library routine called out of sequence

2010-02-23 Thread John
Hi All, The very simple C-code below returns error message library routine called out of sequence . I really don't understand why ? I'm using SQLite 3.6.22 under Windows XP Any idea/suggestion would be really appreciated !

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-23 Thread John
Forgot to say that the error occurs at the sqlite3_close function. John On Feb 23, 11:17 am, John mail_ch...@yahoo.fr wrote: Hi All, The very simple C-code below returns error message library routine called out of sequence . I really don't understand why  ? I'm using SQLite 3.6.22

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-23 Thread Simon Davies
On 23 February 2010 12:51, John mail_ch...@yahoo.fr wrote: Forgot to say that the error occurs at the sqlite3_close   function. John The very simple C-code below returns error message library routine called out of sequence . I really don't understand why  ? I'm using SQLite 3.6.22 under

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-23 Thread Nick Shaw
- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Sent: 23 February 2010 10:17 To: sqlite-users@sqlite.org Subject: [sqlite] sqlite3_close == library routine called out of sequence Hi All, The very simple C-code below returns error message library

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-23 Thread newlog
Hi Simon, Thanx for your answer, IN case of error when trying to open the file, we close db pointer and exit the sub-routine ( return keyword follows closing ). So 'sqlite3_close' can't be called twice. Sincerely, John On Feb 23, 2:40 pm, Simon Davies simon.james.dav...@googlemail.com

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-23 Thread Simon Davies
On 23 February 2010 16:46, newlog newlog2...@yahoo.fr wrote: Hi Simon, Thanx for your answer, IN case of error when trying to open the file, we close db pointer and exit the sub-routine ( return keyword follows closing ). So 'sqlite3_close' can't be called twice. My point was that if the

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-23 Thread newlog
OK, With the following code : - sqlite3*db = NULL; if( sqlite3_open( D:\Test3.db, db) != SQLITE_OK ) { // Exit if error while opening. wxMessageBox( wxString( Error while opening :\n) sqlite3_errmsg(db) );

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-23 Thread Simon Slavin
On 23 Feb 2010, at 5:44pm, newlog wrote: With the following code : - sqlite3*db = NULL; if( sqlite3_open( D:\Test3.db, db) != SQLITE_OK ) { // Exit if error while opening. wxMessageBox( wxString( Error

Re: [sqlite] sqlite3_close == library routine called out of sequence

2010-02-23 Thread Simon Slavin
On 23 Feb 2010, at 10:06pm, Simon Slavin wrote: Change the two error messages so the first one has a '1' in it and the second one has a '2' in it. Then run it again and tell us which of the two error messages is being shown. Ignore that. I got confused. Heh heh. Simon.