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


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

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.