Call the table editor instead of editor views
Steps to Reproduce:
1.Create View from Menu
2.Create any view
4.Try Edit View.
See table editor instead of view editor
I expected to see the view editor
User Profile Reset: No
On pc Debian x86-64 with master sources updated today, I could reproduce this.
(I created an embedded Firebird db from scratch).
Created attachment 153439 [details]
Select operation Edit
Created attachment 153440 [details]
Actual Result Table Designer (for Base View)
Created attachment 153441 [details]
Expected Result - View Designer
I decided to add screenshots to show the selected menu item, the resulting actual mode and the mode I was expecting to see
Have opened the view editor for an internal Firebird database in LO 188.8.131.52. 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 184.108.40.206?
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: https://ask.libreoffice.org/en/question/240210/where-did-edit-view-in-sql-option-go/?answer=240217#post-id-240217
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 220.127.116.11 on OpenSUSE 15.1