Re: [libreoffice-users] Re: Re: SQL statement in Base query

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 <elderdanlewis@gmail.com> wrote:

From: Dan <elderdanlewis@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+help@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+help@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