0

I am using "System.Data.SQLite;". The Dll version is 1.0.103.0.

My sql statement is ALTER TABLE main.[Resistors] RENAME [Manufacturer Part Number] to [Manufacturer Part Number 1]; The error message I get is "Message=SQL logic error or missing database"

I have also tried ALTER TABLE [Resistors] RENAME COLUMN [Manufacturer Part Number] to [Manufacturer Part Number 1]; Which returned "SQL logic error or missing database near "COLUMN": syntax error"

and tried ALTER TABLE main.[Resistors] RENAME COLUMN [Manufacturer Part Number] to [Manufacturer Part Number 1]; Which returned "SQL logic error or missing database near "COLUMN": syntax error

I'm assuming I need to change "main." to something else but I don't know what it should be. Or I need to update my SQLite. I'm working on that.

Eric Minnaert
  • 31
  • 8
  • 1
    Does this answer your question? [How do I rename a column in a SQLite database table?](https://stackoverflow.com/questions/805363/how-do-i-rename-a-column-in-a-sqlite-database-table) – Alejandro Mar 03 '22 at 19:28
  • I tried to add the word "Column" but it didn't seem to help. I'm not sure what I'm missing. – Eric Minnaert Mar 03 '22 at 21:32
  • It looks like my SQLite dll is a bit older. Looks like I can download the setup from this site. Can anyone confirm that this the proper way to set it up or update the dll? https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki – Eric Minnaert Mar 03 '22 at 22:00

0 Answers0