• Registered: 2019-12-28
  • Posts: 4

Topic: Editing SQlite with Navicat

Hi there
This is probably a very simple solution.  If I edit the sqlite database with an external application like navicat it doesnt update the tables etc when I reload mvd.  Any pointers would be appreciated.
Thank you.

  • Registered: 2019-12-20
  • Posts: 18

Re: Editing SQlite with Navicat

AFAIK the table definitions are in tables.ini.
If you change the tables with another application you have to manually change it in MVD.

3 Reply by alanfallow (edited by alanfallow 2019-12-29 22:57:19)

  • Registered: 2019-12-28
  • Posts: 4

Re: Editing SQlite with Navicat

I added a new table in navicat and tried to add it in mvd but it said table already exists but doesnt show up.  Will i need to delete it and add it in mvd?
Thanks

  • Registered: 2019-12-20
  • Posts: 18

Re: Editing SQlite with Navicat

Yes, I think so. I'm using DB Browser for Sqlite. Just for queries.and do my table definitions in MVD.
Perhaps you can try to edit tables.ini with a text editor... don't forget to backup :-)
I do this to sort my tables.

  • Registered: 2019-12-28
  • Posts: 4

Re: Editing SQlite with Navicat

Thank you