Re: [sqlite] Program crashes when delete a row in SQLite db table

[Griggs, Donald]

Hi, Nithin,

Regarding: Corrupted db attached, the qyery crashes is:<br /><br />
delete from 
       objects where dbname='information_schama' 

If it helps, it may be that a single record is giving you trouble, 
  Namely, in table "objects", rowid=2356;


I was apparently successful in obtaining all the other data using:
           CREATE objectsNEW as 
           SELECT * FROM objects WHERE ROWID <> 2356;

Maybe this helps,
   Donald
 

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users