I can see the data in tables and queries. I can even make and modify queries or tables, but I cannot edit,delete or add new rows. The application is behaving like it is locked.
Hello,
Need to know the database used. On the main Base screen on the status bar (very bottom line) in the center it tells the database and on the left the connection. What are these?
The far left shows: Embedded database, the middle left shows HSQLDB Embedded.
How were the tables created - SQL or GUI? If you can see data but not do anything, how did the data get into the tables? Do the tables have a Primary Key assigned to a field?
What OS are you using?
Table and Query create was done GUI. At first I tried to create a table manually via ‘Create Table in Design View’. After it was created, I went to enter/test it, and the screen only showed the fieldnames on top, and the rest of the page was blank. There were no lines and no nav buttons. The next step I tried to create by dragging data from LibreOffice Calc. That worked, but I could not navigate (lower buttons), and I could not delete or enter. I can even add new variable names in the tables, but I cannot edit/delete/add rows or navigate past the end (add). I can create new querys and access the data, but cannot nav or add/change/delete rows in tables. I uninstalled LibreOffice, rebooted, reinstalled LibreOffice and still had the issues the tables. It is like it is record locked, but not definition locked.
Reboot, re-install has no effect. Appears your tables have no primary key field. Edit a table which is not working and see if there is a key symbol to left of any field. If not, that is the problem. Each table must have a Primary key using a unique piece of information for that field.
That did it. Thanks! That would imply that all data models need to conform to 3rd normal form. In the 25+ years that I have been working with various relational databases, I have never know that each table needed a primary key (unique only). LibreOffice is new to me… Is this something specific to LibreOffice?
First neither LibreOffice nor the Base component is a database. Base is a front end to databases. LibreOffice does come with HSQLDB embedded and Firebird embedded (experimental feature) but you can use many others - MySQL, PostgreSQL, MariaDB and many others.
Many databases can operate without a primary key but I believe it is necessary for a variety of situations.
Thanks again for the help.