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 <elderdanle...@gmail.com> wrote:
From: Dan <elderdanle...@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+h...@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+h...@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