Hi,
I don’t seem to be able to change the properties of a field in a table.
Example 1: unable to change ‘AutoValue’ to Yes once the table has been saved (even with empty table)
- make new table > add field “ID” > set to Integer > make it the primary key > save table
- now change AutoValue to Yes > save table → Warning: the column “ID” could not be saved. should the column be deleted and a new column appended? → answering ‘yes’ results in another warning: Error while saving the table design. → unable to save the changes in the table
Example 2: unable to change ‘Entry required’ to Yes when table contains data
- make new table > add a field and make it the primary key
- add new fields: ‘field1’, ‘field2’, ‘field3’
- save table
- enter data for 1 record
- edit the table > set field1 to required=Yes
- save table → Warning: the column “ID” could not be saved. should the column be deleted and a new column appended? → answering ‘yes’ results in another warning: Error while saving the table design. → unable to save the changes in the table > close the table without saving
- edit the table → field1 is now gone
- If you now close the database without saving the changes, then field1 will still be there, but if you close the database while saving the changes, then field1 is gone forever.
Example 3: changing ‘Entry required’ to Yes in empty table changes the order of the fields
- make new table > add a field and make it the primary key
- add new fields: ‘field1’, ‘field2’, ‘field3’
- save table
- enter data for 1 record
- edit the table > set field1 to required=Yes
- save table > → Warning: the column “ID” could not be saved. should the column be deleted and a new column appended? → The only option is to accept appending the column. This messes up the order of the fields. I know this does not affect the functionality of the table, but maintaining a table is much easier when the fields are in a logical order, just like it is much easier to find which letter of the alphabet is missing when the letters are properly sorted.
Questions:
-
Is all this expected/intended behaviour?
-
Is there an easy way to change the order of fields? Can fields be dragged to a new position? Is it possible to insert a row at a desired location?
-
Is it possible to export the design of a table as an SQL statement that can be edited and re-used, so that I don’t have to manually recreate the entire table every time I need to change an attribute of a field?
Using LO 6.2.8.2 on Linux Mint 18.3
tnx!