Ask Your Question
0

pasted Base form not updatable

asked 2019-12-28 09:35:23 +0100

karelc gravatar image

updated 2020-07-24 14:08:46 +0100

Alex Kemp gravatar image

Hi, I'm using Libreoffice base to connect to a Postgres database. The PG database has two tables with identical structures in every respect (there is a valid reason for this!).

I have created a form in LO Base to display the contents of one of the tables, and I can edit/update the fields in the form.

However, when I copy and paste the form and then,in the pasted form, I change the underlying table to the other table , I cannot edit any of the fields. I have checked that the fields allow modifications, which they do. When I click on a column value In the original form it is highlighted and I may change the value, but in the pasted form a dotted box around the particular 'cell' appears, but I cannot change the value.

I'm using Libreoffice 6.3.3.2 and Postgres is version 12.1.

Would someone please let me know where I have gone wrong and how to fix it?

Thanks

edit retag flag offensive close merge delete

Comments

Is the respective ID or key field available in both forms?

ebot gravatar imageebot ( 2019-12-28 11:48:18 +0100 )edit

Yes, I checked the column definitions (in Postgres you can quite easily copy a table with or without the data). I just noticed your reply after I answered my own question.

It's the Libreoffice side of things that I'm unfamiliar with - I'm only using Base for its forms and possibly reports, and frankly I'm at the baby-steps stage!

I'd like to sincerely thank you for your interest and concern - I appreciate your taking the time to consider the problem and taking the time to help.

Thanks,

Karel

karelc gravatar imagekarelc ( 2019-12-28 16:41:29 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-12-28 16:35:06 +0100

karelc gravatar image

Well, I don't know what happened, but it's now working and I didn't change anything. All I did was leave the two machines running and when I came back a couple of hours later, all was (and remains) well.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-12-28 09:35:23 +0100

Seen: 17 times

Last updated: Dec 28 '19