https://bugs.documentfoundation.org/show_bug.cgi?id=116953
--- Comment #5 from [email protected] ---
(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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
