Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index


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+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.