I believe I know what is wrong, it has to do with tables that have implicit indexes. I will upload a new version in an hour. pls give it a try, and let me know. if it does not work, send me your database (zipped).
regards. > -----Original Message----- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 02, 2004 1:08 AM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] new uploads > > > mike cariotoglou wrote: > > I have uploaded the current version of sqlite3Explorer (a GUI to > > manage sqlite3 databases) to http://www.sqlite.org/contrib. also, I > > Hi Mike, > > I was trying to use your sqlite3Explorer program to look at > my database, but > it won't open it. I get a dialog with the following error when I use > File/Open Database... > > --------------------------- > sqlite3explorer > --------------------------- > Could not convert variant of type (Null) into type (String) > --------------------------- > OK > --------------------------- > > After this I am left with schema tree with only one table, > the first one > listed by the .schema command in sqlite3.exe. Using > sqlite3.exe to dump the > database shows all the tables actually exist (ther are 38) as > well as their > associated indexes and triggers. > > I'm using sqlite3.dll version 3.08 built from CVS source, and > the version of > sqlite3Explorer on the SQLite website. > > Any ideas? > > If you want I can send you a copy of the problematic database file. > > P.S. A little further digging shows that it is reading the > database, only > the schema tree view is not working. I can see all the tables with > reasonable counts using the View/Show Tables with Counts > command. Without > the schema tree view working, I can't seem to display the contents of > anything other than the master table, and this first table > (which is empty). >
