Download it now!
Bug 126960 - EDITING: Firebird: Table editor instead of view editor
Summary: EDITING: Firebird: Table editor instead of view editor
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Database-Firebird-Default
  Show dependency treegraph
Reported: 2019-08-16 07:30 UTC by shar
Modified: 2020-04-24 07:17 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Select operation Edit (10.30 KB, image/jpeg)
2019-08-16 15:38 UTC, shar
Actual Result Table Designer (for Base View) (20.47 KB, image/jpeg)
2019-08-16 15:40 UTC, shar
Expected Result - View Designer (46.89 KB, image/jpeg)
2019-08-16 15:41 UTC, shar

Note You need to log in before you can comment on or make changes to this bug.
Description shar 2019-08-16 07:30:47 UTC
Call the table editor instead of editor views

Steps to Reproduce:
1.Create View from Menu
2.Create any view
3.Save view
4.Try Edit View.

Actual Results:
See table editor instead of view editor

Expected Results:
I expected to see the view editor

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 Julien Nabet 2019-08-16 08:29:43 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.
(I created an embedded Firebird db from scratch).
Comment 2 shar 2019-08-16 15:38:12 UTC
Created attachment 153439 [details]
Select operation Edit
Comment 3 shar 2019-08-16 15:40:21 UTC
Created attachment 153440 [details]
Actual Result Table Designer (for Base View)
Comment 4 shar 2019-08-16 15:41:45 UTC
Created attachment 153441 [details]
Expected Result - View Designer
Comment 5 shar 2019-08-16 15:45:14 UTC
I decided to add screenshots to show the selected menu item, the resulting actual mode and the mode I was expecting to see
Comment 6 Robert Großkopf 2020-03-13 15:47:39 UTC
Have opened the view editor for an internal Firebird database in LO on OpenSUSE 15.1 64bit rpm Linux. No problem to open the editor here (but a new while saving views).

Could you confirm the bug has gone in LO
Comment 7 trowelandmattock 2020-04-24 02:52:14 UTC
6.4 Base + Firebird (emb) /Win10 = no 'edit in SQL view" for views
6.4 Base + HSQLDB (emb) /Win10 = 'edit in SQL view' is available for views, as in previous LO versions...

:/  ...possibly 'edit in sql view' has never been available with firebird(embeded) as suggested here:
Comment 8 Robert Großkopf 2020-04-24 07:17:17 UTC
Tested this again with a fresh created view in Firebird. Right mouseclick on the view and there is the possibility "Edit". But it opens only the tableeditor.

There is possible to create a view in the Tasks-pane of Tables. It will work as expected, but you can't edit the view for Firebird after you have saved and closed this editor.

This isn't only a Firebird problem. Have heard of the same problem, for example, in MySQL/MariaDB.

Tested all in LO on OpenSUSE 15.1