Thanks. When I try to verify the database, SQLiteManager seems to hang up doing the check for corrupted indexes. When I try to VACCUM it, SQLiteManager tells me that the database disk image is malformed.
I found an older copy (April of this year), and it checks out ok. I'll try using the older copy to rebuild with. Paul Dobbs Software Engineer, Staff Lockheed Martin Missiles and Fire Control Phone (972) 603-1244 Fax (972) 603-2017 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Bambini Sent: Wednesday, September 06, 2006 11:49 AM To: REALbasic NUG Subject: Re: Database problem Try to check you database with SQLiteManager to see if it is corrupted: http://www.sqlabs.net/sqlitemanager.php and VACUUM it is always a good idea. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ On Sep 6, 2006, at 6:39 PM, Dobbs, Paul wrote: > No. Only one thread, only one user. The database is in the same > directory as the application, both on my PC. > > I am beginning to think that perhaps the database has somehow become > corrupted. That might explain both the original problem (not adding > records in the compiled version) and the new one (the error with the > SQLSelect in the IDE). I have renamed the datbase file and rerun the > program, which creates a new database. I am not getting the error with > it. I may have to rebuild my database from old records. (several > expletives deleted!) > > > Paul Dobbs > Software Engineer, Staff > Lockheed Martin Missiles and Fire Control Phone (972) 603-1244 Fax > (972) 603-2017 _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html> _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
