Re: [libreoffice-users] LO Base Views and Queries
Hi John, ... MySQL/MariaDB with different drivers will be a new thread - or shouldn't we try it per private mail? ... Robert, I have only been following this thread as a lurker, not contributor, but if I may offer a view on that question: I'm surely not the only person finding this thread educational, and do not see this latest turn as off-topic. However, whether or not you find it appropriate to start a new thread, I do hope you will continue on-list. You are doing the world a service. … and I thought: Base - not much people are interested. In a mailinglist I'm missing the possibility to sort the mails by groups, to see something in screenshots. Better solution for this is something like https://ask.libreoffice.org/tag/base If there is any question related to Base I will (try to) answer also on this mailinglist. 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
On 2022-08-12 12:44, Robert Großkopf wrote: ... MySQL/MariaDB with different drivers will be a new thread - or shouldn't we try it per private mail? ... Robert, I have only been following this thread as a lurker, not contributor, but if I may offer a view on that question: I'm surely not the only person finding this thread educational, and do not see this latest turn as off-topic. However, whether or not you find it appropriate to start a new thread, I do hope you will continue on-list. You are doing the world a service. Regards, John -- 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, MySQL/MariaDB with different drivers will be a new thread - or shouldn't we try it per private mail? Which connector do you use? (MySQL or MariaDB? If MySQL: which version?) 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 have chosen the configuration LO-Base front ent to Mariadb backend becuase of the advantage of database server with Terrabytes of disk space. But I am wondering seriously whether I have made a good choice. There seem to be serious compatibilty problems between them in spite of the LO MySQL(JDBC) driver interface. For example, The GUI tells me that 3 arguments required by the LO-Base DATEDIFF() function is to incorrect, and accepts only two arguments (as per MYSQL). But a LO-Base query with 2 arguments, which is syntactically accepted, returns no data. I am beginning to feel a bit frustrated with this LO-Base/Mariadb idea. That would be a pity, as the GUI would theoretically be good to avoid all the SQL typing work (not really within the scope of my expertise), and the Forms and Reports are a bonus that is missing in the phpMyAdmin environment. But perhaps it's just the hot weather. Cheers Harvey On Fri, 2022-08-12 at 10:09 +0200, Robert Großkopf wrote: > Hi Harvey, > > > OK. Thanks, Robert. That is more or less the conclusion that I had > > come > > to. Not very user-friendly, but it works. > > Reason for this behavior might be you are using a server database for > many users. Have had a look with PHPMyAdmin. Couldn't edit the view > there also. > > 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, OK. Thanks, Robert. That is more or less the conclusion that I had come to. Not very user-friendly, but it works. Reason for this behavior might be you are using a server database for many users. Have had a look with PHPMyAdmin. Couldn't edit the view there also. 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
OK. Thanks, Robert. That is more or less the conclusion that I had come to. Not very user-friendly, but it works. Cheers Harvey On Fri, 2022-08-12 at 08:36 +0200, Robert Großkopf wrote: > 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 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