Re: [Libreoffice] ODBC literal escapes in LibreOffice

Le 02/09/11 18:05, Lionel Elie Mamane a écrit :

Hi Lionel,

> 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. For example, instead of using an SQL query
> prepared on the fly, using a prepared statement and using (interface
> XParameters) e.g. setDate / setTime / setTimestamp to insert the
> values in a "compatible with all databases" way. This would have the
> advantage to making LO more compatible with eventual other databases
> that do not support the ODBC escapes.

I don't know the ins and outs of such a change at the core functionality
level, but you definitely have my round of applause if you want to go
that way. The date literal thing (which was also present in StarOffice)
has been a pain in my butt for a very long time, say, more than 10 years
lol !!!

How would you envisage the prepared statement working with the filter
functionality currently available in forms, for example, where this
transition from date literal is transparent for the user (because the
query is generated on the fly) ?

Just my 2c.

Alex