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: http://www.familiegrosskopf.de/robert > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ Privacy Policy: http://www.documentfoundation.org/privacy
