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

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