Re: [libreoffice-users] Re: disable base query auto-correction

On Thu, 2011-10-06 at 12:19 +0200, Alexander Thurgood wrote: 

> Le 06/10/11 11:40, Daniele Palumbo a écrit :
>
> Hi Daniele,
>
> > i have a query (see thread "problem in sql query") that is not
> > "standard", and libreoffice change it according to its standard when i
> > open it in "structure view", a sort of auto-correction.
> >
> > how can i remove it?
>
> Hmm, "structure view" is a new one to me, perhaps you mean Query Design
> view ? In this case, the LibO SQL parser is always ON. In order to turn
> off the parser, you have to leave the Design mode by clicking on the
> corresponding button (Toggle Design Mode On/Off), and then deactivate
> the SQL parser button (which by default will be on).
>
>
> The problem itself is unfortunately not new. The SQL parser that LibO
> uses is unfortunately a bit limited, because it was considered during
> Sun OOo times that it would be impossible to cater for every flavour or
> version of SQL ever implemented (which is a fair enough assumption). So,
> if you want to use all of the functionality that your backend SQL engine
> supports, then you are better off deactivating SQL parsing. If you want
> to have the benefits of the graphical design tool for designing your
> queries, then you are stuck with what the parse can manage.

Translating SQL statements between databases is buggy at best. Depending
on version and developer different levels of support for SQL standard
are implemented along with in-house extensions that do not have
equivalents in other databases. 

> Additionally, as you have discovered, the conversion between SQL parser
> and SQL native throughput does not always work properly. If you can
> identify specific conversion problems, please open bug reports for each
> one using the bug reporting assistant here :
>
> http://www.libreoffice.org/get-help/bug/
>
>
> Alex



-- 
Jay Lozier
jslozier@gmail.com

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