--- Nigel Metheringham <[EMAIL PROTECTED]> wrote:
> I'll see if I can reproduce the result with standard INSERT statements
Try this:
sqlite3 orig.db vacuum -- might be necessary to preserve row order
sqlite3 orig.db ".dump BrokenTable" | tee orig.sql | sqlite3 new.db
sqlite3 new.db ".dump BrokenTable" | diff -u0 orig.sql -
If it does not work, just load orig.db into sqlite3, ATTACH new.db and
then write a SELECT that returns the new.db rows that do not exactly match
the original table using ".mode insert".
sqlite> .mode insert
sqlite> select * from ...
____________________________________________________________________________________Fussy?
Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay
it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
