[Libreoffice-bugs] [Bug 116953] EDITING: UI: Firebird: Migration: Base fails to call QueryEditor for defined database view

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116953

--- Comment #5 from robert at familiegrosskopf.de ---
(In reply to robert from comment #4)
> Seems impossible to edit a created view with Firebird:
> https://bugs.documentfoundation.org/show_bug.cgi?id=76072#c6

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180417/4fdaf17c/attachment.html>