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