Apache OpenOffice (AOO) Bugzilla – Issue 117820
Msaccess pass-through query, error creating report
Last modified: 2013-01-29 21:43:05 UTC
Created attachment 76361 [details] Zipped Access 2000 file test.mdb Hi, the problem is: if I create a Msaccess pass-through query (ie I have to filter by date a Msaccess table), and then when I try to create a report from this query, I obtain an error "The field names from '..' could not be retrieved". Here are the steps to obtain the error: 1. Create a Base (ver. 3.30) .odb file attached to Access 2000 "test.mdb" file (see attachment), containing the "Table1" table with a unique field, "FirstDate", type "date", and three records 2. Create a new query with the text: select * from Table1 where FirstDate = #01/01/2011# Click on the "Run SQL command directly" button to make a pass-through query, then save as "Query1" 3. Right click on the "Query1" query and select "Report Wizard..." option, you can see the error "The field names from 'Query1' could not be retrieved.' Dario
I can confirm it same happens in OOo 3.2.1, and OOo 3.4 Beta (m106). The same error when you try to create report from query, with report builder, no field name listed. Another test, connect to MS example file Northwind with any type of connection, I tested with ADO. Create query: SELECT * FROM orders where orderdate = #1994-08-08# The error same, "The field names from 'Query1' could not be retrieved. No fields in report designer fields lists. SELECT * FROM orders where shipregion = 'AK' works correctly, no errors, all fields listed on report designer field lists. The problems with the #YYYY-MM-DD# date format. Same #YYYY-MM-DD 00:00# timestamp format.
reassign to the right developer
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.