The following error occurs when I make a call to GetSchema only when I use the "Columns" collectionname. It is complaining about "A94c06h01copy"; this table no longer exists in the database (it probably did at one time but was deleted by DROP). That table does not appear in the "Tables" collection according to GetSchema. It appears that the table name still exists in the columns list, so the provide is throwing an exception.
This has corrupted the database, and the VACUUM command doesn't fix it.
Perhaps your provider can trap this error so that, even if the columns internal table is not quite right, all is not lost. I'll be glad to send you a copy of the database if you want.
Thanks
System.Data.SQLite.SQLiteException occurred
ErrorCode=-2147467259
Message="SQLite error
no such table: main.A94c06h01copy"
Source="System.Data.SQLite"
StackTrace:
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteConnection.Schema_Columns(String strCatalog, String strTable, String strColumn)
at System.Data.SQLite.SQLiteConnection.GetSchema(String collectionName, String[ restrictionValues)
at System.Data.SQLite.SQLiteConnection.GetSchema(String collectionName)
at WRDB.UI.frmDBExplorer.lstSchemaCollection_SelectedIndexChanged(Object sender, EventArgs e)