I had a table with 4 columns and with some rows of datas in it. Then I added a new column and soon after I removed it, without saving the table layer after that I add the column. Then all the data stored into the table were lost Reproducible: Always Steps to Reproduce: 1. Create a table and some column in it 2. Store data into the table 3. Add a column (assigning name of the column and type of data), then delete it. Actual Results: All data stored in the table are lost Expected Results: All data stored in the table shoud remain
Hi Francesco, thanks for the report. Kexi warns users about this behaviour, this is actually all that can be done. Advanced users as a poor workaround can use external tools like sqlite3 command line tool or sqliteman. I am marking this report as a duplicate of "Add support for alter table's design without losing data" wish (https://bugs.kde.org/show_bug.cgi?id=125253) which is scheduled for Kexi 2.7 - we're working hard to deliver the best possible user experience. *** This bug has been marked as a duplicate of bug 125253 ***