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)
Version:
(earliest affected)
6.3.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
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:


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

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
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:
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 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?
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: https://ask.libreoffice.org/en/question/240210/where-did-edit-view-in-sql-option-go/?answer=240217#post-id-240217
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 6.4.3.2 on OpenSUSE 15.1