Author Topic: DBLib column modification (fixed)  (Read 2118 times)

0 Members and 1 Guest are viewing this topic.

Online dunkemhigh

  • Super Contributor
  • ***
  • Posts: 4211
DBLib column modification (fixed)
« 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)
« Last Edit: August 24, 2021, 11:27:19 pm by dunkemhigh »
 

Offline thm_w

  • Super Contributor
  • ***
  • Posts: 3658
  • Country: ca
  • Non-expert
Re: DBLib column modification
« Reply #1 on: August 24, 2021, 08:57:41 pm »
So restoring an older version of the dblib file does not fix it?
 

Online dunkemhigh

  • Super Contributor
  • ***
  • Posts: 4211
Re: DBLib column modification
« Reply #2 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.
 

Online dunkemhigh

  • Super Contributor
  • ***
  • Posts: 4211
Re: DBLib column modification
« Reply #3 on: August 24, 2021, 11:27:00 pm »
Fixed.

Problem turned out to be library path which has somehow got changed to 'NUMERIC'. Duh!
 
The following users thanked this post: thm_w


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf