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

2022-08-11 Thread Harvey Nimmo
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, >

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

2022-08-11 Thread Robert Großkopf
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

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

2022-08-11 Thread Harvey Nimmo
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

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

2022-08-11 Thread Robert Großkopf
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

[libreoffice-users] LO Base Views and Queries

2022-08-11 Thread Harvey Nimmo
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