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+unsubscr...@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