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

Hi :)
If you are using Base with the internal back-end then it is highly likely
to be a twisted form of HSqlDb.

Apparently it is fairly easy to export an internal database so that you can
use an external HSqlDb database program.  You would need to install HSqlDb
as a separate program.
http://hsqldb.org/

Base would then be a front-end using the external HSqlDb as a back-end.  Of
course Base could then be using Forms and Reports done in Writer or Calc as
a front-end to it's front-end so Base would be kinda in the middle.


This is a MUCH better way of using Base.  The internal back-end has all
sorts of weird problems and has even suffered from data-loss for quite a
few people.  As an external back-end the proper version of HSqlDb is fairly
solid apparently.


There is an inherent problem with Sql, as you have already found out.
Although it is supposedly an agreed standard each program that uses it adds
it's own extra commands and changes things around a bit.  So it's difficult
to copy Sql commands that were written for other programs but they can
still be a useful way of getting ideas and sometimes may only need a little
translating for whichever program you are using at the time.
Regards from
Tom :)

On 20 March 2015 at 02:49, Justin Musgrove <JMusgrove@plexsys.com> wrote:

> On Thu, 2015-03-19 at 19:21 -0700, xavier2 wrote:
> > Hi, seems to be LibreOffice base it's using HSQLDB...
> > However, I don't know if there is available any website describing
> examples
> > of code of HSQLDB for LibreOffice Base...
> > someone here knows any?
>
> There is a good tutorial that helped me understand how base works on
> their wiki.documentfoundation page. The book is called Base_tutorial by
> Mariano Casanova. It has examples for sql code, forms, queries, reports,
> and views.
>
> Direct link:
> https://wiki.documentfoundation.org/images/0/02/Base_tutorial.pdf
>
> JM
>
> --
> 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

-- 
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