Re: [libreoffice-users] Which SQL standard does LibreOffice Base support?

     Yes, when Base uses a different database engine to connect to a 
database. HSQLDB, MySQL, Oracle, and PostgreSQL each has differences in 
how it uses SQL. Even different versions of any of these will have 
differences.  Each newer version has improvements in how SQL is 
implemented and what additional commands can be used. That is why having 
the user guide for the specific database engine and version that you are 
using is so important.
     Specific example: DATEDIFF() for finding the difference of two 
dates in days in 2012. When used in a Base embedded database, the format 
it is: DATADIFF('dd','2012-12-02','2012-10-17'). When connecting to 
MySQL 5.1 the format is DATDIFF('2012-12-02','2012-10-17'). When using 
HSQLDB 2.2.8, you can use either of these formats. (Note: when using 
HSQLDB 2.2.8, you can not connect to an embedded Base database. You must 
first extract the database folder in the .odb file and then use Base to 
connect to this folder.
     HTH

--Dan

> Hi :)
> So does Base's version of Sql change when a different back-end is used?
> Regards from
> Tom :)
>
>
> --- On Sat, 30/6/12, Dan <elderdanlewis@gmail.com> wrote:
>
> From: Dan <elderdanlewis@gmail.com>
> Subject: Re: [libreoffice-users] Which SQL standard does LibreOffice Base support?
> To: users@global.libreoffice.org
> Date: Saturday, 30 June, 2012, 15:06
>
> Ioannis Vranos wrote:
> > Hi all,
> >
> > I would like to know which SQL standard, the default installation of
> > LibreOffice Base supports under GNU/Linux.
> >
> >
> > Thank you,
>       Base uses the HSQLDB version  1.8 as its database engine. LO and AOO Base still use this 
> version. The link below is the user guide for HSQLDB. What you need is found in chapters 8 and 9 
> which discuss the use of SQL when using Base. It will mention what SQL standards it will use, 
> outlines for SQL statements, and its own special SQL it uses.
>
> https://wiki.documentfoundation.org/images/c/c9/Hsqldb_guide.pdf
>
> --Dan
>
>
> -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted