Base 7.1.2.2 in Ubuntu does not allow data entry or edit. How to resolve?

asked 2021-04-25 01:56:08 +0200

KPS158 gravatar image

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.

edit retag flag offensive close merge delete

Comments

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?

Ratslinger gravatar imageRatslinger ( 2021-04-25 02:31:33 +0200 )edit

The far left shows: Embedded database, the middle left shows HSQLDB Embedded.

KPS158 gravatar imageKPS158 ( 2021-04-25 03:52:24 +0200 )edit

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?

Ratslinger gravatar imageRatslinger ( 2021-04-25 03:59:21 +0200 )edit

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.

KPS158 gravatar imageKPS158 ( 2021-04-25 04:16:31 +0200 )edit

@KPS158,

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.

Ratslinger gravatar imageRatslinger ( 2021-04-25 04:39:14 +0200 )edit

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?

KPS158 gravatar imageKPS158 ( 2021-04-25 05:48:15 +0200 )edit

@KPS158,

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.

Ratslinger gravatar imageRatslinger ( 2021-04-25 06:28:40 +0200 )edit

Thanks again for the help.

KPS158 gravatar imageKPS158 ( 2021-04-25 14:26:45 +0200 )edit