[libreoffice-users] Re: Using SQL functions in LibreOffice base (notation)

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:
> http://www.hsqldb.org/doc/1.8/guide/ch09.html

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
better solutions).


-- 
To unsubscribe e-mail to: users+unsubscribe@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