Hi :) If only it were possible to somehow communicate with people from the various back-end projects perhaps even ask them to write-up a brief sub-chapter on how to use their back-end in conjunction with Base. I wonder if any of them know anything about the use of Sql in their projects.
The BoD want to sit&wait rather than be pro-active about this sort of collaboration. Regards from Tom :) --- On Mon, 23/7/12, Dan <elderdanle...@gmail.com> wrote: From: Dan <elderdanle...@gmail.com> Subject: Re: [libreoffice-users] Re: Re: SQL statement in Base query To: users@global.libreoffice.org Date: Monday, 23 July, 2012, 22:54 Ferry Toth wrote: > Did you try with another database as a backend? I like postgres as a > backend a lot. > > Ferry I am writing a chapter of the Base Guide that includes using SQL in the Query Design dialog. Chapter 8 of the Base Guides covers using HSQLDB 2.2.8, MySQL, and PostgreSQL as back ends. So, I am not there quite yet. It seems that because Base uses HSQLDB 1.8, it does not conform with the user guide for the database engine it uses. When I get to that point, I will need to research how each of these backends use SQL. --Dan > > Dan schreef op wo 18-07-2012 om 16:40 [-0400]: > >> Andreas Säger wrote: >>> On this simple level I would consider HSQLDB as free of bugs whereas the >>> primitive Base parser fails in many different ways. >>> Did you try the direct SQL mode (SQL view, menu:Edit>Run SQL directly)? If >>> you get reasonable result in direct mode, it is one of many bugs in the >>> Base's SQL parser. >>> >>> -- >>> View this message in context: >>> http://nabble.documentfoundation.org/SQL-statement-in-Base-query-tp3996273p3996282.html >>> Sent from the Users mailing list archive at Nabble.com. >>> >> >> That is the one thing that I forgot to mention: I get the same >> message when using direct SQL mode. I even tried using Tools > SQL, but >> with the same message. >> >> --Dan >> >> > -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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