https://bugs.documentfoundation.org/show_bug.cgi?id=89418
Bug ID: 89418 Summary: Query don't work with directly connect at Microsoft Access file (not Access 2007) Product: LibreOffice Version: 4.3.5.2 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Base Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: mariano.ca...@outlook.com On my file .odb connected directly at Microsoft Access file, now my Query get this error : SQL Status: 3075 Error code: -2147217900 Syntax error (missing operator) in query expression ''2012-2013' `Campagna`'. This is the query : SELECT '2012-2013' AS `Campagna`, 'OLIO' AS `Prodotto`, `DO_NUDOC` AS `NrDoc`, `DO_DTDOC` AS `DataDoc`, `DO_DESTI` AS `Cliente`, `DO_TOTAL` AS `TotFattura` FROM `DOCUMENTI` WHERE `DO_TPDOC` = 'FT' AND `DO_DESTI` IN ( '222', '180' ) If I connect my .odb via ODBC the query work fine, but i have worked correctly with LO < 4.3 and direct connection at file .mdb Tried on 2 pc with LO 4.3.5 and 4.1.1 OO 4.1.1 work ! -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs