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 <[email protected]> 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: [email protected] > 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: [email protected] 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
