Thanks, so far...;-) I understand that a View would be more efficient
in execution than the equivalent query. And this seems to be more or
less the practical extent of justification for view over query.
Version: 184.108.40.206 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 2; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
How do I identify the internal db used? Firebird (version 220.127.116.11045-
1.7) is installed in my configuration, HSQLDB is not.
I think I understand your tip to mean that i should use queries until
they are 'final' and then create views as appropriate.
On Thu, 2022-08-11 at 16:38 +0200, Robert Großkopf wrote:
I'm unsure of the practical implications of the difference between
implementation of Views and Queries. Perhaps someone can enlighten
One thing, however, does hit me.
Views will be executed in the database. The content will look for
like a non-writable table. You could filter data, sort data and use
views for repprts, but you couldn't update, add or delete data.
Database won#t know anything about queries in the queries pane.
will send from tBase to the database. So queries will be a little bit
slower. But queries could be used for input, update or delete data,
all primary keys of the included tables were available.
Initial design of a View with the GUI, is done similar to a Query,
which is OK. However, when the View is stored, then further
of that View seems very limited if not impossible, as the Table-
GUI is opened on Edit.
Which version pf LO and which (internal) database do you use? This
(opening table editor, not query editor) has been solved for internal
Firebird database some times ago. In LO 18.104.22.168 the query editor will
One hint: I will save all views separately as queries. It is because
view could depend on another view. So I couldn't chang the view I
created, if another view needs data of this view. I have to delete
views depending on this view and have to recreate them afterwards.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy