<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - EDITING: UI: Firebird: Migration: Base fails to call QueryEditor for defined database view" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116953#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - EDITING: UI: Firebird: Migration: Base fails to call QueryEditor for defined database view" href="https://bugs.documentfoundation.org/show_bug.cgi?id=116953">bug 116953</a> from <a class="email" href="mailto:robert@familiegrosskopf.de" title="robert@familiegrosskopf.de">robert@familiegrosskopf.de</a> <pre>(In reply to robert from <a href="show_bug.cgi?id=116953#c4">comment #4</a>) > Seems impossible to edit a created view with Firebird: > <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED WORKSFORME - Not allowed to create view with embedded Firebird ?" href="show_bug.cgi?id=76072#c6">https://bugs.documentfoundation.org/show_bug.cgi?id=76072#c6</a> Have tried a little bit more: Tools > SQL CREATE OR ALTER VIEW "viewTest" AS SELECT * FROM "table" WHERE "ID" > 4 Works. A View will be created. But LO will show this view (after refreshing the tables) as table. I could see it is a view, because I change something in "table" and is has been changed also in the view. Now CREATE OR ALTER VIEW "viewTest" AS SELECT * FROM "Leser" WHERE "ID" < 5 Works. The view with the same name could be changed. You could get the code for the view with SELECT RDB$RELATION_NAME, RDB$VIEW_SOURCE FROM RDB$RELATIONS WHERE RDB$VIEW_SOURCE IS NOT NULL So it must be possible to load this code to the GUI-query-editor, change the code and put it back to the database.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>