Re: [libreoffice-users] LO Base Views and Queries

Hi Robert,

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.

My version:
Version: 7.3.4.2 / 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
Calc: threaded

How do I identify the internal db used? Firebird (version 3.0.4.33045-
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.

Cheers
Harvey


On Thu, 2022-08-11 at 16:38 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> > I'm unsure of the practical implications of the difference between
> > Base
> > implementation of Views and Queries. Perhaps someone can enlighten
> > me.
> > One thing, however, does hit me.
>
> Views will be executed in the database. The content will look for
> Base 
> like a non-writable table. You could filter data, sort data and use
> this 
> views for repprts, but you couldn't update, add or delete data.
>
> Database won#t know anything about queries in the queries pane.
> Queries 
> 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,
> if 
> 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
> > development
> > of that View seems very limited if not impossible, as the Table-
> > type
> > GUI is opened on Edit.
>
> Which version pf LO and which (internal) database do you use? This
> bug 
> (opening table editor, not query editor) has been solved for internal
> Firebird database some times ago. In LO 7.4.0.2 the query editor will
> appear.
>
> One hint: I will save all views separately as queries. It is because
> a 
> view could depend on another view. So I couldn't chang the view I
> first 
> created, if another view needs data of this view. I have to delete
> other 
> views depending on this view and have to recreate them afterwards.
>
> Regards
>
> Robert
> -- 
> Homepage: https://www.familiegrosskopf.de/robert


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy