EEVblog Electronics Community Forum

Electronics => PCB/EDA/CAD => Altium Designer => Topic started by: dunkemhigh on August 24, 2021, 12:57:29 pm

Title: DBLib column modification (fixed)
Post by: dunkemhigh on August 24, 2021, 12:57:29 pm
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)
Title: Re: DBLib column modification
Post by: thm_w on August 24, 2021, 08:57:41 pm
So restoring an older version of the dblib file does not fix it?
Title: Re: DBLib column modification
Post by: dunkemhigh on August 24, 2021, 09:52:35 pm
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.
Title: Re: DBLib column modification
Post by: dunkemhigh on August 24, 2021, 11:27:00 pm
Fixed.

Problem turned out to be library path which has somehow got changed to 'NUMERIC'. Duh!