Re: [libreoffice-users] LO Base Views and Queries
Hi Harvey, I cannot confirm the Firebird icon. My database backend is MySQL(JDBC), (actually Mariadb). I prefer to continue for the time being with the OpenSUSE packages delivered with my Linux Leap 15.4. Editing views with external databases won't work. It's the same behavior for every other connection with MySQL/MariaDB, also with PostgreSQL. So: Create queries, save it as a query, create a view of this query. For changing a view: Edit the query you have saved. Delete the view. Create the view from the query again. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] LO Base Views and Queries
Hi Robert, I cannot confirm the Firebird icon. My database backend is MySQL(JDBC), (actually Mariadb). I prefer to continue for the time being with the OpenSUSE packages delivered with my Linux Leap 15.4. Cheers Harvey On Thu, 2022-08-11 at 18:06 +0200, Robert Großkopf wrote: > Hi Harvey, > > LO won't be installed without internal HSQLDB. But with that behavior > you reported you are using internal Firebird. Will be shown at the > bottom of the window in statusbar. > > You are using packages from your distribution, not from LO directly. > Have tested the same version you are using, only from LO directly: > Version: 7.3.4.2 / LibreOffice Community > Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5 > CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 > (cairo+xcb) > Locale: de-DE (de_DE.UTF-8); UI: de-DE > Calc: threaded > > If I choose to edit views they will be opened in this version with > the > query editor. > > Regards > > Robert > -- > Homepage: https://www.familiegrosskopf.de/robert > -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] LO Base Views and Queries
Hi Harvey, LO won't be installed without internal HSQLDB. But with that behavior you reported you are using internal Firebird. Will be shown at the bottom of the window in statusbar. You are using packages from your distribution, not from LO directly. Have tested the same version you are using, only from LO directly: Version: 7.3.4.2 / LibreOffice Community Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5 CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded If I choose to edit views they will be opened in this version with the query editor. Regards Robert -- Homepage: https://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: users+unsubscr...@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
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+unsubscr...@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
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+unsubscr...@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
[libreoffice-users] LO Base Views and Queries
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. 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. Is there a way to return to the Query-type feature to continue modifying the View design once the View has been stored and closed? -- To unsubscribe e-mail to: users+unsubscr...@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