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
