Hi,
I'm using OpenOffice Base since a while, and I haven't found how to solve my
problem. I've a form that contains a field of type Date. I'd like to use the
filter option provided by Base, to do a filter like dates > 2001-01-01.
But when I specify > 2001-01-01 in the filter mode of the form, it reformats
what I've written, like this : > #2001-01-01#. Trying to execute the filter
gives me a PostgreSQL error :
Impossible d'actualiser le contenu des données, pq_driver:
[PGRES_FATAL_ERROR]ERROR: syntax error at or near "{" at character 49
(caused by statement 'SELECT * FROM "archeo"."Sites" WHERE ("date" > {D
'2001-05-10'})'
So it seems to be a matter of {D } characters, that are added and not well
parsed.
I'm using the driver sdbc in version 0.7.6, and this behaviour is the same
on OpenOffice 2.4.1 and 3.0 on Linux for me.
How can I prevent the {D} character to come in the filter, surrounding my
date value ? Is it possible ?
Kind regards,
Cédric
--
View this message in context:
http://www.nabble.com/PostgreSQL-form-and-filter-problems-for-date-fields-tp19957602p19957602.html
Sent from the openoffice - dba users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
