Ask Your Question

field property readonly using hsqldb standalone mode [closed]

asked 2016-09-08 17:49:57 +0100

philho94 gravatar image

updated 2020-09-12 07:38:15 +0100

Alex Kemp gravatar image


i use libreOffice 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

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-12 07:38:24.266531

1 Answer

Sort by » oldest newest most voted

answered 2016-09-08 19:09:11 +0100

Ratslinger gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-09-08 17:49:57 +0100

Seen: 50 times

Last updated: Sep 08 '16