On Fri, Sep 02, 2011 at 06:05:18PMr +0200, Lionel Elie Mamane wrote:
LibreOffice uses ODBC escapes for literals, e.g. for dates: {D
2011-08-28} In particular, it does that when one asks for a filter
on a date column in a form or table.
Now, for example PostgreSQL does not support that syntax.
So, I wanted to check whether it is policy that SDBC drivers must
accept ODBC escapes in SQL strings (and the PostgreSQL SDBC driver
will have to be changed so that it does), or whether there would be
interest in me gradually changing LibreOffice to *not* use
ODBC-specific escapes.
I found out about the EscapeDateTime and EnableOuterJoinEscape
properties that disable this ODBC escape behaviour, and changed the
PostgreSQL SDBC driver to set them. So I'm not going to pursue my idea
to use prepared statements instead of dynamically generated SQL, at
least for the time being.
--
Lionel
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.