Description: 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:
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 6.4.2.1. 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 6.4.2.1?
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 6.4.3.2 on OpenSUSE 15.1
I gave a try here: https://gerrit.libreoffice.org/c/core/+/129011
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0adff3f2476f797843fb62d6810de90bfb333e10 tdf#126960, tdf#131330: FB make views editable+refresh auto after creation It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
For 7.3, patch waiting for review here: https://gerrit.libreoffice.org/c/core/+/129067 Robert: To respond comment 8 about Mysql part, I did some work on Mysql/Mariadb, it should be ok now to edit views. However, since there were lots of changes, it won't be backported in 7.3 branch.
(In reply to Julien Nabet from comment #11) > For 7.3, patch waiting for review here: > https://gerrit.libreoffice.org/c/core/+/129067 > > Robert: To respond comment 8 about Mysql part, I did some work on > Mysql/Mariadb, it should be ok now to edit views. However, since there were > lots of changes, it won't be backported in 7.3 branch. Thanks Julien, will test it next Monday.
The patch doesn't build on 7.3 branch and don't want to dig so I abandoned it. If someone wants to try, don't hesitate.
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/e7c652b90c44d9615a89e88ad3aa195b1fa6fbf7 tdf#126960, tdf#131330: FB make views editable+refresh auto after creation It will be available in 7.3.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 116953 has been marked as a duplicate of this bug. ***
(In reply to Commit Notification from comment #14) > Julien Nabet committed a patch related to this issue. > It has been pushed to "libreoffice-7-3": > > https://git.libreoffice.org/core/commit/ > e7c652b90c44d9615a89e88ad3aa195b1fa6fbf7 > > tdf#126960, tdf#131330: FB make views editable+refresh auto after creation > > It will be available in 7.3.1. > > The patch should be included in the daily builds available at > https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More > information about daily builds can be found at: > https://wiki.documentfoundation.org/Testing_Daily_Builds > > Affected users are encouraged to test the fix and report feedback. Thank you Xisco for having fixed the pb!