https://bugs.freedesktop.org/show_bug.cgi?id=77154
--- Comment #4 from [email protected] --- Created attachment 97316 --> https://bugs.freedesktop.org/attachment.cgi?id=97316&action=edit Database and csv-file. Table in database with autovalue I have changed the order of the steps: 6. Tools/SQL: SET TABLE "Example" SOURCE "Example.csv;ignore_first=true;encoding=UTF-8"; 7. Edit the table Example 8. Set Autovalue Yes for ID and save to 6. Edit the table Example 7. Set Autovalue Yes for ID and save 8. Tools/SQL: SET TABLE "Example" SOURCE "Example.csv;ignore_first=true;encoding=UTF-8"; Seems it must be so: http://hsqldb.org/doc/guide/ch06.html "ALTER TABLE commands that add or drop columns are not supported with non-empty text tables." You can try this way: " SET TABLE mytable SOURCE OFF Subsequently, mytable will be empty and read-only. However, the data source description will be preserved, and the table can be re-connected to it with SET TABLE mytable SOURCE ON " -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
