Ask Your Question

Base form fields do not allow entry [closed]

asked 2012-05-26 21:55:52 +0200

RichA gravatar image

updated 2015-10-16 04:12:33 +0200

Alex Kemp gravatar image

I am using Base to connect to a remote Mysql database.

I intended to create some forms, using the form wizard, to enter new data and change data.

Well, I can't overwrite any of the fields in the form, and I can't seem to get to a sport where I can add a new record. Basically all I can do is look at the data that's there.

I followed a tutorial on youtube in which someone created a NEW table in base and used a form to add records to it. Seemed simple there, but I can't duplicate what he's doing.

Any suggestions would be appreciated.

Here's my libreoffice version:

LibreOffice 3.3.4 OOO330m19 (Build:401) tag libreoffice-, Ubuntu package 1:3.3.4-0ubuntu1


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 04:12:48.064855

1 Answer

Sort by » oldest newest most voted

answered 2012-05-27 17:47:55 +0200

RichA gravatar image

Finally realized Base did not know that these tables had primary keys.

Editing the tables under Base to mark the key fields as keys did not work.

What worked was to copy/paste the tables under Base, specifying the primary keys during the paste step, then dropping the original table and renaming the copy to the name of the original. Each new table is apparently identical to the old one, but now Base knows about its primary key and allows adds/changes.

edit flag offensive delete link more

Question Tools


Asked: 2012-05-26 21:55:52 +0200

Seen: 2,284 times

Last updated: May 27 '12