https://bugs.freedesktop.org/show_bug.cgi?id=59978
Priority: medium
Bug ID: 59978
Assignee: [email protected]
Summary: EDITING: assistant does not read dates
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.5.6.2 release
Component: Database
Product: LibreOffice
Let the following table: COUREUR(NUMLICENCE, NOM, PRENOM, DATENAISSANCE), the
last field being a DATE.
We created a query in QBE or SQL mode (both work):
select * from COUREUR where DATENAISSANCE > '1952-06-30'
When we try to create the same query using the assistant, it ignores the
content of the field in which we typed '1952-06-30' and gives the error
"unexpected )".
The query understood by the assistant is:
select * from COUREUR where (DATENAISSANCE > )
And the same happens whatever we type in the field: 06/30/1952 or 30/06/1952 ou
#30/06/1952#, even {D '1952-06-30'} as it appears in some SQL editing of
QBE-made queries.
It appears to be a bug of the assistant, isn't it?
Sincerely
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
