Topic: How do I modify an existing table
Hello,
I deployed an application which went into use and the customer later required additions. I kept working on the application in MVD and added a field to one of the tables. I then asked the customer to send me their sqlite.db file and I thought it was possible to modify the table structure of the file using DB Browser for SQLite and then put that file in with the updated MVD application and all would be well. It didn't go well and I have attached the error message screen shot from DB Browser for SQLite.
Can somebody please tell me the best way forward in this type of situation where I modify a table in an application and then get the customer data file which has had data being added to it and needs updating to the latest structure..
Thanks in advance.
David