1

LibreOffice 5.1.6.2

I have saved some queryes and I'd like to allow users to use them directly (without any reports). Reason: there are filters thare, they are convenient. My users are sophisticated ones, so queries are ok.

The problem is a possibility to edit data when looking at the results of the selection.

Please, have a look at the picture: enter image description here

In the tool bar there is a button called "Edit data". By default editing possibility is switched on.

I'd like to switch this editing possibility off constantly. Could you help me here?

Michael
  • 4,273
  • 3
  • 40
  • 69

1 Answers1

0

Queries can only be edited if Base can directly match up each record with a unique key. There is a brief discussion on this topic here.

One simple way to prevent Base from doing this is to wrap the query in another one. Edit the query in SQL view.

SELECT * FROM ( SELECT "ID", "PlantID", "Notes" FROM "Tasks" )

read-only query

Even though the Edit Data button is not disabled, clicking on it will have no effect. When the query is closed and opened, the button is disabled.

Jim K
  • 12,824
  • 2
  • 22
  • 51