On 23 Aug 2011, at 4:28pm, a.azzol...@custom.it wrote: > I cannot run a shell sqlite3 on my embedded system. I will explain it > using your example.
At some point your database file is becoming corrupt. > It happen that sometime autoincrement begin to fail > and new records overwrite the one at rowid =1 > > 1|1|2|3|one|two|three replaced by 1|4|2|3|one|two|three > 2|2|2|3|one|two|three > 3|3|2|3|one|two|three Can you stop at this point, copy the resulting database file back onto your desktop computer, and run PRAGMA integrity_check() on it using the shell tool ? If it passes the integrity_check there, can you then execute the next INSERT on it, then do the same test ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users