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