Am 20.03.2015 um 13:08 schrieb xavier2:
Hi there, yes that is right, but what is completely weird is that LibreOffice
Base, using a modified SQL don't have a reference book showing all these
modifications and notations? then where can we find reference for that
modification of the SQL language?
Look at the status bar of your "Base database" (in fact there is no such
thing as a "Base database").
There you might read something like "HSQL" and "embedded".
And this is the full documentation of the embedded HSQL 1.8:
Threre is no such thing like Access in LibreOffice. This office suite
does not come with any full featured database development suite.
It comes with database connectivity for several purposes related to
office documents and -- very unfortunately -- it comes with a copy of
HSQL version 1.8 which is used to generate new relational databases
which are -- catastrophically -- embedded within a zip container, the so
called "Base document". This office suite can do a whole lot of useful
things with databases (external ones, even HSQL databases). But you must
not not believe that you can develop beautiful database applications for
your customers. Far away from that.
If you happen to be a patient (macro) programmer, database admin,
Writer/Calc guru and SQL wizard, you may squeeze a lot more out of this
package. But then you are more or less on your own (and thinking about
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: 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