hello
i use libreOffice 5.2.0.4 with hsqldb in standalone mode ( vers. 2.3.3). It works well but i have some trouble i can’t suppress rows when i open a table with OpenOffice (LibreOffice) . I am obliged to launch an SQL query like Delete from …
The fields of my table created with OpenOffice can’t be modified ( create ok ). I must suppress the old field definition and recreate a new one…
i don’t know why ?
i need some help , i didn’t find anything on the web
thank you
Based upon your information, when you say standalone I believe you are saying a split database. In this case once tables are created, they cannot be edited as the embedded tables can. This is the only drawback I see to the split DB. You are right in that any editing cannot be done to existing fields. You can get around this somewhat. You can add and delete fields (you don’t need SQL for this). To delete just select the row (it will then be highlighted) of the field and hit delete key. To add just go to a new line and enter the new field. You just can’t change existing fields.