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).
