Base, cannot edit View

[silvain-dupertuis]

Using LibreOffice 24.2.7.2 on Linux / Ubuntu 24.02
I cannot edit a Table View

• I can add or delete a view
• I can convert a query into a view.
• But once a view is opened for edition, I can only see the liste of fields but I cannot even see their properties (for calculated fields) nor the tables on which the view is built

[CRDF]

On what database?
Here in a dummy Firebird Embedded View > Edit
it shows up on GUI and asks for saving the changes.
Rem: But didn’t try to alter it indeed.

[silvain-dupertuis]

That was with HSQLBD. Now that I converted my base to Firebird, Edit View functions.
Note that I needed to do a few changes after the conversion for the converted base to function, and one of these changes involves a correction that needs to modify a parameter in the content.xml file inside the uncompressed odb file (not properly documented).

[RobertG]

If HSQLDB won’t work well together with Base there must be something special done with the packages or Java you are using. HSQLDB is better integrated in GUI than Firebird.

You have to change ParameterNameSubstitution - think this is what you have found as a bug:
117589 – Firebird: set the "ParameterNameSubstitution" parameter at migration time. It could be solved like described here:
Chapter 2 Creating a Database (end of the chapter). Could also be solved by

SUB FB_Parameter
 DIM oSettings AS OBJECT
 oSettings = ThisComponent.DataSource.Settings
 oSettings.ParameterNameSubstitution = True
END SUB

But better would be to solve the bug instead, which still exists since 7 years…