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

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.

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



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