First time here? Check out the FAQ!
asked 2012-05-26 21:55:52 +0200RichA
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-126.96.36.199, Ubuntu package 1:3.3.4-0ubuntu1
answered 2012-05-27 17:47:55 +0200RichA
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-05-26 21:55:52 +0200
Seen: 591 times
Last updated: May 27 '12