Re: [sqlite] TRANSACTION-question

2004-12-03 Thread P. Morandi
Yes, you do it. Bye - Original Message - From: Steven Van Ingelgem To: [EMAIL PROTECTED] Sent: Friday, December 03, 2004 10:02 AM Subject: Re: [sqlite] TRANSACTION-question Do you automatically end a transaction when committing? At 09:11 3/12/2004, you wrote: Hi St

Re: [sqlite] TRANSACTION-question

2004-12-03 Thread P. Morandi
Hi Steven, I used transactions in C++ code (windows and linux) with sqlite 2.8; try the sequence " BEGIN; DELETE ...; INSERT ...; COMMIT; ", it works in 2.8. Regards Paolo - Original Message - From: Steven Van Ingelgem To: [EMAIL PROTECTED] Sent: Friday, December 03, 2004 8:51 A

Re: [sqlite] DATABASE SCHEMA HAS CHANGED

2004-11-21 Thread P. Morandi
That's true, I didn't mention the version, sorry ... It's 2.8. I need to execute again the statement to solve the problem. Thanks to everybody Paolo - Original Message - From: "Randall Fox" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 21, 2004 6:21 AM Subject: Re: [

Re: [sqlite] DATABASE SCHEMA HAS CHANGED

2004-11-19 Thread P. Morandi
Thank you Tito. I'll try it. Bye - Original Message - From: "Tito Ciuro" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 19, 2004 12:38 PM Subject: Re: [sqlite] DATABASE SCHEMA HAS CHANGED > Hello Paolo, > > On Nov 19, 2004, a

[sqlite] DATABASE SCHEMA HAS CHANGED

2004-11-19 Thread P. Morandi
Hi everybody. After using VACUUM on a sqlite db, the first time I try to do an INSERT in a table (always the same table) I get the "DATABASE SCHEMA HAS CHANGED" error, but later queries have no problems, only the first one. If I don't pack the db (no using of VACUUM) no problem. Does anyone have

[sqlite] Library routine called out of sequence

2004-10-22 Thread P. Morandi
Hi everybody. Does anybody know the main causes of error 'Library routine called out of sequence' after a sqlite_exec() calling? Thank you. P. Morandi

[sqlite] library routine called out of sequence

2004-10-20 Thread P. Morandi
Good morning. I just subscribed to the list. I've been using Sqlite for an year without problems, but recently I have to face up quite often with the error "library routine called out of sequence" and it seems I can't solve it definitely. I'll explain better: I'm programming under Linux (I'm no