Re: [libreoffice-users] Calculated values in View or Query

That is marvellous. Thank you, Robert!!
I must get used to visiting the Document Foundation website, as I tend
to stick with the help function and otherwise OpenSUSE. Excellent tip.

The Base Guide answers my question precisely, listing as it does the
built-in functions together with a remark in each case "[Works in the
GUI]" - or not (e.g. CASE)

Great stuff!!
Harvey

On Wed, 2022-08-10 at 10:06 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> most SQL code I create direcly without using GUI, so I don't know if
> all 
> of this could also be created through GUI.
>
> Have a look at the Base Guide
> https://nextcloud.documentfoundation.org/s/qjFkGwpEEkNrt6f.
> The GUI has been created to work perfect with internal HSQLDB (very 
> old…), but there is no special SQL-version, which isn't running in LO
> Base. Base Guide will show you the code for internal HSQLDB and also
> for 
> Firebird - and some hints for other databases.
>
> 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