[sqlite] Corrupted sqlite_sequence table

2008-06-03 Thread James P
I would remove the leading/trailing quotes external to the import of the file, using something like sed or gawk. I couldn't work out how to do this purely using sqlite, however. _ It's simple! Sell your car for just $30 at

Re: [sqlite] Corrupted sqlite_sequence table

2008-06-02 Thread Samuel Neff
great, thanks! On Mon, Jun 2, 2008 at 11:55 AM, Dennis Cote <[EMAIL PROTECTED]> wrote: > Samuel Neff wrote: > > Were you able to successfully reproduce the corruption using the scripts > and > > databases I sent? We're having a lot more trouble with this problem and > our > > earlier workaround

Re: [sqlite] Corrupted sqlite_sequence table

2008-06-02 Thread Dennis Cote
Samuel Neff wrote: > Were you able to successfully reproduce the corruption using the scripts and > databases I sent? We're having a lot more trouble with this problem and our > earlier workaround is proving troublesome in some situations. > I think it has been fixed. See

Re: [sqlite] Corrupted sqlite_sequence table

2008-06-02 Thread Samuel Neff
Were you able to successfully reproduce the corruption using the scripts and databases I sent? We're having a lot more trouble with this problem and our earlier workaround is proving troublesome in some situations. Thanks, Sam On Wed, May 28, 2008 at 7:25 PM, D. Richard Hipp <[EMAIL

Re: [sqlite] Corrupted sqlite_sequence table

2008-05-28 Thread D. Richard Hipp
On May 28, 2008, at 7:21 PM, Samuel Neff wrote: > It happens every time. I can send you a db and the update scripts, > but I'll > need you to keep it confidential (not signed affidavit or anything > like > that, just understanding that it's confidential). > > Please confirm this is ok and

Re: [sqlite] Corrupted sqlite_sequence table

2008-05-22 Thread D. Richard Hipp
On May 22, 2008, at 7:02 PM, Samuel Neff wrote: > I have a corrupt sqlite_sequence table. It has table names in the > "seq" > field. > > here is a trimmed version of data in sqlite_sequence: > > > -- Loading resources from C:\Documents and Settings\sam/.sqliterc > SQLite version 3.5.7 > Enter

[sqlite] Corrupted sqlite_sequence table

2008-05-22 Thread Samuel Neff
I have a corrupt sqlite_sequence table. It has table names in the "seq" field. here is a trimmed version of data in sqlite_sequence: -- Loading resources from C:\Documents and Settings\sam/.sqliterc SQLite version 3.5.7 Enter ".help" for instructions sqlite> .width 50 50 sqlite> select * from