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, at 10:24, P. Morandi wrote: > > > 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 any idea of the causes of this error message? > > I believe VACUUM changes the schema version numbering. After you > VACUUM, your sqlite3 struct holds information about your previous > database version. Solution: reopen the database and SQLite will pick up > the new changes. After that, INSERT will not report an error (until you > VACUUM again, that is.) > > I hope this helps, > > -- Tito > > >