I am using Devart ODBC driver to give me a DBLib. Works very well. Now I decide I need to add a new column to my capacitors table, which is pretty easy to do in the sqlite3 database. Trouble is, when I now open Designer I get a message that the database has changed and the capacitor table won't show any fields. Which I guess is fair enough, but how do I get things synced again? I can't find anything that lets me update, reread or whatever.
There is quite a lot of setup in the DBLib so vaping it and recreating it isn't my preferred option.
Edit: Added the error dialog whenever the DBLib is accessed (or Altium opened)
So restoring an older version of the dblib file does not fix it?
No. The only way to fix it is to revert to the database without the new table column.
It seems the problem is Altium knows the table is different to the one it was set up for, but doesn't give a way to say that's OK and either ignore the change or allow it to be used.
Fixed.
Problem turned out to be library path which has somehow got changed to 'NUMERIC'. Duh!