Attached has a database corrupted. We use the version 3.6.23.1 in wince. the command: pragma integrity_check;
show many errors and Duplicate pk was founded using: SELECT u_pkey, count(*) FROM tp_gpsdata GROUP BY u_pkey HAVING count(*) > 1 ; this returns only 1 record SELECT * FROM tp_gpsdata WHERE u_pkey IN (4684, 4879) ORDER BY u_pkey DESC LIMIT 10; deletes one record only DELETE FROM tp_gpsdata WHERE u_pkey IN (4684, 4879); vacuum; doesn't works because of pk constraints. I'm seeding because that can be a bug in OS or in sqlite and maybe someone can see that, Thanks for your time! -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Software Ltda.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users