Firbird Base - Forms - ReadOnly Value ignored

asked 2019-09-11 12:47:02 +0200

fgotsis gravatar image

updated 2021-06-04 12:57:50 +0200

Alex Kemp gravatar image

I am running LibreOffice and on OpenSuse Leap 15.1 The issue appears after migrating to Firebird using Forms programmed with libreoffice basic and is reproducible. Changing the ReadOnly property is ignored, field remains readonly. This problem occurs only if the field is connected to a view field or an analyzed SQL statement. Even unsetting teh Textfield to be connected to view field does not change anything. Creating a non connected field (not connected to any field of a view or an SQL statement) does not show this problem.

Code example

txtFieldName = oForm.getByname("txtName") txtFieldName.ReadOnly = FALSE

Using Firebird the setting is ignored, using HSQLDB the setting is doing what it should do: It allows the modification of the field (using the same Libreoffice versions).

Ugly workaround: Set setting ReadOnly in the form of the field to true. Save the form. Change the setting back to False. Save the form again. Then change from edit mode to life input mode and the field is editable. Using the embedded HSQLDB this problem does not appear.

Oh: Querying the setting (getPropertyValue) delivers the setting as it was set by the program, but it is simply ignored.

Any help is highly appreciated. kind regards Franz

P.S.: The changed field content is read by the program and then reused in an SQL statement to update the record.

edit retag flag offensive close merge delete



Please attach a sample Base file with the problem.

Edit: Have seen no problem with some basic testing, therefore sample is needed. Field properties should not be affected regardless of DB used.

Ratslinger gravatar imageRatslinger ( 2019-09-11 17:59:39 +0200 )edit